Compacting

[cheftim]

I'm just about done with my database and will be putting it on the user's computer shortly. How often, generally, should we compact and repair the DB? Is this something I should set as an event everytime the file is closed? Is there any disadvantage to doing it too often?

Thanks,
t

 

[RuralGuy]

Here's a link of ghudson's to give you something to think about. http://www.access-programmers.co.uk/forums/showthread.php?t=114688&highlight=Compact+Close

 

[cheftim]

Thanks again RuralGuy. Good information.

 

[RuralGuy]

Any time.