Hi All,
Just looking for some assistance....
I have an access database which has an autorun which sets off before my team gets in in the morning using autoexec and schedualed task.
The database goes through to almost 60 small databases (under 3mb each) and appends to a master table in the database. Occassionally before the overnight run takes place a user can be left connected to the database, either through there own fault or due to server latancy. We've implements a timeout function which will force access to quit at a certain time at night for all users..
As a secondary precuation we want to add in a OnError Resume next, while this element is easy enough to do what I want to be able to do is generate some sort of log file or error table, or something which will tell us which parts have errored and skipped over.
I've googled around with not much luck..
Can anyone assist me.
Thanks
Just looking for some assistance....
I have an access database which has an autorun which sets off before my team gets in in the morning using autoexec and schedualed task.
The database goes through to almost 60 small databases (under 3mb each) and appends to a master table in the database. Occassionally before the overnight run takes place a user can be left connected to the database, either through there own fault or due to server latancy. We've implements a timeout function which will force access to quit at a certain time at night for all users..
As a secondary precuation we want to add in a OnError Resume next, while this element is easy enough to do what I want to be able to do is generate some sort of log file or error table, or something which will tell us which parts have errored and skipped over.
I've googled around with not much luck..
Can anyone assist me.
Thanks