Cannot Compact and Repair

[Guest]

I have an Access 2003 database split into front-back ends. The back end is on
a server. Once a week I perform a Compact and Repair on the back end. This
time, however, I get an error message that Microsoft has encountered a
problem and needs to close. I am them prompted to save it and try to repaoir
the open database, but that doesn't work wother. I end up in a loop-- name
the backup, then get an error message, then name another backup , then get
another error message, etc.

I tried moving the back-end to my local driver to see if that would work--
no dice, same error message. The back end has swelled to about 53 MB (it
should be about half that). It still seems to work, but I'm getting very
nervous.

What can I do? Any ideas? THanks.

 

[Van T. Dinh]

It sounds like there are corruptions in your Back-End.

See Tony Toews' Web site:

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Arvin Meyer [MVP]]

Try importing all your tables into a new empty database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks for the tip re the the Toews site, Van.

Thanks for your suggestion, Arvin. Access would not import the corrupt file
to a clean database, but the proces helped me identify the problem table (I
could see which table the system crashed on). I was then able to search the
table for the corrupt record and delete it. That seemed to do the trick,
because I was then able to complete the conpact and repair process.