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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Access Lock File .LACCDB / Now shows as a notepad file 0
access 2010 delete confirmation 1
unable to open my mdb file - please help! 1
Is there a way to find the size of each database object? 7
MDB with only linked tables growing tremendously 15
How can I to try to recover .mdb database size 800mb? 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top