Compact back-end database

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi Folks - Question ... I have a FE and BE Access 2000 database
configuration. If I choose the option to compact on close for the BE
database, will it be compacted, or do I need to explicitly open and close
the BE db. If so, what techniques are people using to automatically compact
the BE db? Thanks.

Michael
 
It should work, although I am wary of doing these kind of operations on a network. I would copy it locally, compact it and then load it back to the network.

-------------------------------------------------------
For your FREE Access beginners ebook

http://www.access-databases.com/ebook

-------------------------------------------------------
 
Back
Top