[blue]I have a DB that is accessed by multiple users. Is there any way to compact the DB on a scheduled basis (e.g., daily)? Do I need to have exclusive access to the DB to do this? How do I kick everyone off prior to the DB being compacted?
Trying to compact a database while other users have it open will cause a problem, so you do need exclusive access to do it. You may be forced to come in "after hours" to do it.
HTH
George
You could use the Windows Scheduled Tasks to open the database during closing hours, with the Compact on close Option'.
Add an autoexec macro with Docmd.Quit
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.