I can't compact or repair an Access database

[Ladyzzaj]

When I try to compact and repair an Access 2003 database the process appears
to start then I get an error message. All it says is 'Access has encountered
a problem and needs to close.' The 'repair/compact' database button is
checked and the process is started again. How can I compact this file?

 

[Tony Toews]

When I try to compact and repair an Access 2003 database the process appears
to start then I get an error message. All it says is 'Access has encountered
a problem and needs to close.' The 'repair/compact' database button is
checked and the process is started again. How can I compact this file?

Oliver covered the basics. In the event that those steps are
insufficient. then see the following.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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