Compact an open database

C

cafe

You can not do it to an open one. That would be like having abdominal
surgery in the middle of your evening meal ...

HTH,
TC
 
D

dan

hi...

i know you can use do "compactdatabase" to a closed one,
but how would you do it to an open or current one?

thanks,
dan
 
T

tina

you've probably compacted your open db many times while
working on it, by simply clicking Tools, Database
Utilites, Compact. if you're wanting your user to be able
to compact the db, but don't want to give him/her access
to the Tools menu, then create a custom menu and COPY the
Compact selection over to it from the Database Utilites
submenu. this should work fine in A2k (or later,
presumably).
keep in mind that you don't want multi-user dbs compacted
by users "at will" (such as a "backend" db on a server).
but any db that sits on a user's hard drive and is
accessed only by the PC's current user (this
includes "frontend" dbs) can be compacted at any time. the
easiest way to do this is to set up the db to compact
automatically when the db closes (Tools, Options, General
tab, Compact on Close).

hth
 

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

Top