Compact and Repair on Close with multiple users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I read in a previous posting to use Tools > Options > General tab to set a
database to compact and repair on closing. If I set this up on a database
with multiple users, will it affect any entries that are being made by one
user when another user closes the database? Any help would be appreciated.
 
1) If you set "Compact & Repair on Close", it will only take effect when the
last person closes the current file. It's sort of a "will the last person
turn out the lights when they leave" option. The file has to be available
exclusively in order to Compact it, so there's no danger to anyone else
currently in the db since anyone else in the db would prevent it from
happening.

2) If you have a FrontEnd/Backend setup, "Compact & Repair on Close" won't
do anything to the backend when users close the frontend. The command would
only apply to the Frontend being closed, which is (generally) much less
likely to be need of compacting.

3) If you have multiple users using the same Frontend, or a single-file mdb,
over a network, do yourself a favor and devote some resources to changing
that situation before you find yourself spending all your time addressing
data corruption issues.
 
Thank you so much for your help. Compact and Repair on Close is only a
stop-gap measure until we get our frontend/backend set up. Thanks again for
the answer and the advice!
 
Back
Top