Compact freezing

[Guest]

I am trying to do a compact and repair on my database, but it keeps freezing
and giving the microsoft has encountered and error half way through. I
really need to fix is there any thing anyone can think of or suggest. I have
never had this happen before, its very frustrating. Thanks

 

[Tony Toews]

I am trying to do a compact and repair on my database, but it keeps freezing
and giving the microsoft has encountered and error half way through. I
really need to fix is there any thing anyone can think of or suggest.

This is a sign of corruption. I'd start by importing the tables and
relationships into a new MDB.

Otherwise make a copy of the corrupt MDB and start working through the
items at the following page.

To retrieve your data from a Corrupt Microsoft Access MDB
http://www.granite.ab.ca/access/corruption/retrievedata.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

 

[Guest]

Thanks, I am working on it.

This is a sign of corruption. I'd start by importing the tables and
relationships into a new MDB.

Otherwise make a copy of the corrupt MDB and start working through the
items at the following page.

To retrieve your data from a Corrupt Microsoft Access MDB
http://www.granite.ab.ca/access/corruption/retrievedata.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