Hi, John.
For a shared database if you set Access to automatically Compact and Repair
on Close does it only do so when the last person in the database closes
Yes. If Access attempts to compact the database when someone else has it
open, the compaction will fail. However, with a split database, this doesn't
affect the front end because no one else will be sharing the front end, since
every user should have a copy of the front end on his own workstation.
Compact on Close will only affect the back end if this option is set on the
back end database file, and only when the last person closes the back end of
the database.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
