Deleted records but didn't change file size

  • Thread starter Thread starter Mike D
  • Start date Start date
M

Mike D

I have an existing database that has reached over 20MB
and can take a while to access over a network. So, I
copied the file and backed up the old one. I then
deleted all of the records.
Why hasn't my file size changed?? I was expecting it to
go down to under 100kb. Is there some extra "purge" that
needs to be done??
 
Space that was used for deleted Records are not automatically recovered.
You need to compact the database to recover the unused space in the
database.

The Compact (and Repair) command is available in the Menu Tools / Database
Utilities...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
delete does not reduce the file size 1
Deleting specific records based on query results 3
reduce Access 2007 database size 6
Can't delete file 3
How do I archieve database file to decrease the size of the file 2
The Database is over 4 M in size see is missing over 400 records 4
Delete Record question 9

Back
Top