DB Maintenamce

[Earl Anderson]

Dave,

Did you tell me you did this already to the front end?.

From:
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000010

Database Maintenance
General Database Maintenance - Over time an MS Access database can become
corrupt and can require some 'cleaning'. Access has a built-in function that
will, as it's name suggests, Compact and Repair the database. Depending on
the frequency of use of the database, the frequency of which a database must
be compacted and repaired may vary. However, a good practice to avoid this
issue altogether is to simply set the database to compact and repair on
close. This option can be set by going to the Tools-Options...-General Tab
and check the Compact on Close check box.

 

[Earl Anderson]

Sorry...Missent to this group...
Earl

 

[Tony Toews [MVP]]

General Database Maintenance - Over time an MS Access database can become
corrupt and can require some 'cleaning'.

This is wrong. Corruption happens due to external events.
Corruption doesn't happen "over time"

That said you should be doing periodic compacts.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/