Compact BackEnd

[MaureenKLM]

Access XP database with a FrontEnd separate from the B/e (Tables). The B/E
file is stored on a server and the multiple users (about 20) have individual
copies of the F/E file stored on the local PC. At any point in time, there
may be up to 10 users accessing the B/E but it's usually closer to 4-5.

I want to write a macro to Repair & Compact the backend file - anyone out
there have experience with doing this? Is it safe to do if some users are
still accessing the B/E through their open FrontEnds? Is there a recommended
"on event" to attach such a macro to?

Thanks for any help you can offer!

 

[Douglas J. Steele]

You cannot compact if other users have connections to the database: Access
won't let you. You can write code to look whether or not the locking file
(.ldb) exists or not, and compact when it doesn't.