Why the database size does not reduce after deleted several large tables?

M

Min

Hi, I added some large tables to an Access database, the size increased from
several MB to over 20 MB. But when I delete these tables, the size of the
database still keep the same value as before. Why the database size does not
reduce after deleted several large tables? What can I do to reduce its size?
 
J

Joseph Meehan

Min said:
Hi, I added some large tables to an Access database, the size increased
from
several MB to over 20 MB. But when I delete these tables, the size of the
database still keep the same value as before. Why the database size does
not
reduce after deleted several large tables? What can I do to reduce its
size?
Click to expand...

You need to do a repair and compact. Look under the tools - database
utilities menu.
 

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
Reduce size of database? 1
Database file size and linked tables.... 4
Does no. of tables affect database speed? 5
Size of database keeps growing. 3
optimize database 2
large database file size after new table addition 4
Reducing Database Size 2

Top