Access Table Delete does not reduce the *.mdb file size

  • Thread starter Thread starter HELP on Access
  • Start date Start date
H

HELP on Access

When I delete a table from Access, the size of *.mdb file
does not change. Like the table is still residiing in
the database but not visible. How can your purge it.


I am new to access. Thanks in advance.
 
You would need to do a Compact and Repair (found in the Tools menu) on your
database to recover the space and reduce the size of the file.
 
Use the Compact and Repair database option found under
the Tools' menu Database Utilities option.
 
Access / JET does not recover space automatically. You need to use the Menu
Tools / Database Utilities / Compact Database to compact the database and
recover the space.
 

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

delete does not reduce the file size 1
MDB with only linked tables growing tremendously 15
unable to open my mdb file - please help! 1
access 2010 delete confirmation 1
Is there a way to find the size of each database object? 6
Deleted MDB file 2
Record-Locking remains open after closing 0
reduce Access 2007 database size 6

Back
Top