Deleted records but didn't change file size

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??
 
V

Van T. Dinh

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...
 

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

Deleting specific records based on query results 3
Database file size and linked tables.... 4
reduce Access 2007 database size 6
The Database is over 4 M in size see is missing over 400 records 4
Deleting file and path 4
Damaged Outlook 2010 file prevents indexing. Am I doing the right repairs? 0
Ghost references to deleted tables in a back end database (Access2000 XP) 5
Copies being made and Records being deleted by Access 3

Top