My database won't compact

[LynnEsther]

Help! Suddenly and without warning, my Access 2000 database will not compact. When I go to compact/repair nothing happens. Does anyone out there know what may have caused this and what I can do to fix it? My database is growing by the hour and desperately needs to be compacted.

Thanks in advance.

Lynn

 

[DCrake]

1st question:

Is the database split? Front End Back End?

If split is it the FE or BE that won't compact

If not split, most likely you have corrupted mdb.

 

[ghudson]

I would create a new database and import all of the db objects from the old database into the new database.

 

[LynnEsther]

Thank you for the suggestion to create a new db and import the objects. That's what I did and all is well.