Compacting a Database

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

There's no way to compact an open database.

You can add code to the database to log them out after a period of
inactivity (see http://support.microsoft.com/?id=210297 for one approach)

Another approach is to add a table to the database that holds a status flag.
You can set that status flag to indicate when all users should exit the
database. Check the status as you enter each form, and in, say, the Current
event of the commonly used forms.

Of course, one approach is to schedule the compacts to run in the middle of
the night, assuming no one's using it then.

FMS sells a couple of products that might be of use. Total Access Admin will
check who's got it, and allow you to prevent other users from entering it
http://www.fmsinc.com/products/Admin/index.asp while Total Visual Agent will
allow you to schedule compaction
http://www.fmsinc.com/products/agent/index.html
 
I have a database that is used by several people. At any
given time, someone has the database open for use.

I need to be able to perform database maintenance
(compact) to reduce the size of the file.

(1) Any way of doing compact while someone has the
database open?

(2) Can I close them out, via VBA code, to allow database
maintenance? I have code that tells me who (userid) and
where (machine ID).
 
Thankyou, your first suggestion looks most appropriate.
The lab stays open 24/7, so there really isn't a "middle
of the night".

Thanx again!
 
Back
Top