repair and compact database

hi

how can i auto repair and compact my database each time the database is closed???

pls advice
nono

Why??

If this system potentailly used by more then one person at a time? You will cause problems in this case. I usually add the feature to my customer menu and just trained the users when to use it.

To answer you question it is possible, but I will have to research it.
S-

hi thank for the help.

i heard i can have the auto repair and compact by going to tools , options, under the general tab, check on the compact on close.

thanks
nono

That is an option you can use, you would not use this options on a database used over the network though. As the administrator you would do this when everyone is offline.

S-

hi,

thanks for the advice.

cheers,
nono