Can't Compact an Access 2000 Database

R

rl_davis

I have a Microsoft Access 2000 database that will not compact. When I
compact it the process begins and then locks up about half way through.
I have tried to do this on other computers thinking it might be that
computer without success. I tried making it an MDE unsuccessfully.

There is not an error message it simply just not continue past the half
way mark. The database is approximately 20,000K in size.

I have left it in hopes that it would just take a while. I have left it
compacting for an hour and finally shut it down.

Any thoughts on how to salvage this database?

Any help would be greatly appreciated.

Thank in advance.
 
F

Frank Stepanski

Hi,

Your database does not seem too large for compacting not to work. Try this:
Open a blank database, File Import, Select your database you cannot compact
and import the entire database (tables, forms, forms, etc) to it. See if
that works.

I have done this in the past and it has worked for some of those "weird"
issues that you cannot find a solution for.

Frank Stepanski
 
T

tomandla

Try creating a new database and importing all your queries, etc. into
it. (If you have any linked tables, you will probably have to relink
them.) If there are any corrupt queries, etc., they will not import
but you will receive an error message. Write down those item(s) that
will not import. You will have to recreate them in your database ...
at least you'll have the old database to look at for guidance.

Hope this helps. It has worked for me when I've had this type of
problem.
 
T

Tony Toews

[email protected] said:
I have a Microsoft Access 2000 database that will not compact. When I
compact it the process begins and then locks up about half way through.
I have tried to do this on other computers thinking it might be that
computer without success. I tried making it an MDE unsuccessfully.
Click to expand...

You've already got some good advice regarding importing into a new
MDB.

If that doesn't work then 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
 
R

rl_davis

I finally got this to work. I could not get the above suggestions to
work but was able to resolve problems when I identified a bad or
corrupt record. I then pasted the structure of the table and appended
all but the corrupt record. Now I am able to compact and export record.

Hope this can help someone else. Thanks to everyone who brought
suggestions.

Robert
 
Top