B
bmullin via AccessMonster.com
Hi,
I have a macro that sets off a series of update queries. In esence, it
updates address information on small databases, using address information on
our company wide database. I use tables linked through DBO connections to
our company db, to udate the smaller Access tables.
I set Setwarnings to Off, so it doesn't stop at the end of each step. There
are about 15 queries involved. The whole process takes a couple hours to run,
so I usually set if off before I leave for the night. The one problem is, I
suspect sometimes that not every step went off as it was supposed to, because
of system problems etc.
Is there a way to keep a log of the errors, without stopping the whole
process? I'd like to see the error, then maybe go back and manually rerun
just the affected query.
Thanks
Brian
I have a macro that sets off a series of update queries. In esence, it
updates address information on small databases, using address information on
our company wide database. I use tables linked through DBO connections to
our company db, to udate the smaller Access tables.
I set Setwarnings to Off, so it doesn't stop at the end of each step. There
are about 15 queries involved. The whole process takes a couple hours to run,
so I usually set if off before I leave for the night. The one problem is, I
suspect sometimes that not every step went off as it was supposed to, because
of system problems etc.
Is there a way to keep a log of the errors, without stopping the whole
process? I'd like to see the error, then maybe go back and manually rerun
just the affected query.
Thanks
Brian