Compact on close

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

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

--

Ken Snell
MS ACCESS MVP

"Ashley" wrote in message
...
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

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.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Ashley" wrote in message
...
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