The situation:
I have an mdb on a server that needs to be compacted every night.
It is a multi-user mdb and is only accessed through VB via ODBC. It has no forms, etc and is strictly used as a database.
I need to make sure everyone is out of the mdb (and they should be after mid-night) and then I need to have it compacted automatically.
I know I can set the mdb to compress when closed but will this take place when the last user exits the system?
Should I, and is it possible to, create an mdb that through VBA will open the mdb on the server and compact it?
I tried doing this using DBEngine.compact but I could not get it to work because of a syntax problem.
Any help/suggestions would be appreciated!
I have an mdb on a server that needs to be compacted every night.
It is a multi-user mdb and is only accessed through VB via ODBC. It has no forms, etc and is strictly used as a database.
I need to make sure everyone is out of the mdb (and they should be after mid-night) and then I need to have it compacted automatically.
I know I can set the mdb to compress when closed but will this take place when the last user exits the system?
Should I, and is it possible to, create an mdb that through VBA will open the mdb on the server and compact it?
I tried doing this using DBEngine.compact but I could not get it to work because of a syntax problem.
Any help/suggestions would be appreciated!