Compact back-end database

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
 
P

paul23

Joined
Jan 12, 2009
Messages
17
Reaction score
0
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

-------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maintenance Recomendations -Compact? 11
Compact Database 3
Huge tempory access space 1
Message Code Causing PC Error 2
break points to find out why it doesn't compact or copy 2
Compact on Close - beware? 4
compacting database on terminal server 3
Compact on close 3

Top