Compact & Repair

[gumby]

My database will not compact and repair. Get gives me an error message
that it needs to save it as a backup and reopen to fix. However it just
stays in this cycle creating several backups. (It also wants me to send
a message to Microsoft) The database seems to work fine and I am not
sure if it corrupted. Has anyone seen this before?

David Isaacks

 

[gumby]

My database will not compact and repair. Get gives me an error message
that it needs to save it as a backup and reopen to fix. However it just
stays in this cycle creating several backups. (It also wants me to send
a message to Microsoft) The database seems to work fine and I am not
sure if it corrupted. Has anyone seen this before?

David Isaacks

I think it is related to one table. I am now having a problem with one
table. I can open it, but when I scroll to the right it gives me the
same error. Also i cannot export it or copy it. I also cannot import it
into another database.

Thanks - David

 

[Van T. Dinh]

It sound like a corruption in the Table or even just one Record.

See the following Microsoft Knowledge Base articles:

http://support.microsoft.com/kb/306204

http://support.microsoft.com/kb/247771

and Tony Toews' article:

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

 

[gumby]

Thank you. I had found that article, but did not quite understand it.

However, after you replied I went and read it again. I finally found
the record that was corrupted and removed it.

Thanks again - David