Hi
I have 40 or so .csv files attached to my access xp.mdb. I am running a macro of about 40 append quires. If I pickup a damaged or partial file - that append query will fail. I do not get an option of continue or ignore. It halts the entire macro. Is there any way to disregard that query and allow the macro to continue. Set warnings in macro does not work. I have converted to code with DoCmd.OpenQuery and DoCmd.SetWarnin gs. I can't get that to work either.
Thanks,
Craig
I have 40 or so .csv files attached to my access xp.mdb. I am running a macro of about 40 append quires. If I pickup a damaged or partial file - that append query will fail. I do not get an option of continue or ignore. It halts the entire macro. Is there any way to disregard that query and allow the macro to continue. Set warnings in macro does not work. I have converted to code with DoCmd.OpenQuery and DoCmd.SetWarnin gs. I can't get that to work either.
Thanks,
Craig