Compact on close

[Ashley]

My database is 49MB.
Compact on close always lock up on closing. I often have
to end the task through task manager.
Is there something I can do to eliminate this problem?

Ashley
Thanks

 

[Ken Snell [MVP]]

Database may be corrupt. Create a new database and import all objects into
the new database.

 

[Roger Carlson]

Don't use Compact on Close. On my website (see sig below) is a small sample
database called "CompactDatabase.mdb" which shows how you can write your own
compact utility. The real advantage is the control it gives you to create a
backup that you can name so you can recover if anything goes wrong with the
compact.