I need to run 3 access database, what we do is they are sch to run at night, they create copie of table we use for reporting on the next day. We do this because we found it is faster then accessing the the database during the day. I have 3 because 1 was to large. The problem is they are sometimes hanging up at night causing a server reboot in the morning.
The MDB as an autoexec macro that does the update query then closes access.
I want to run 1 and then when it is done the next and the next.
What would be the best way to handle something like this
The MDB as an autoexec macro that does the update query then closes access.
I want to run 1 and then when it is done the next and the next.
What would be the best way to handle something like this
