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

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

Cheryl Fischer

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

Dennis

Use the Compact and Repair database option found under
the Tools' menu Database Utilities option.
 
V

Van T. Dinh

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
Is there anything I can do to keep the file size small? 2
Error Message after exporting MS Access Table 0
Is there a way to find the size of each database object? 6
mdb format and Access 2007 3
MS Access cant change the data type ; there is not enough disk space or memory. 4
unable to open my mdb file - please help! 1
Cannot open MDB 9

Top