delete table in access

[zwasdl]

I deleted a big table in access db, but the size of the db didn't
reduce. How do I make the db to reflect it in size?

 

[TPratt]

The db needs to be "Compacted". Usually found in the Tools/Database
Utilities menu.

 

['69 Camaro]

Hi.

You'll need to compact the database after you've deleted the data in order
to actually remove the space from the file that is no longer being used.
Select the Tools -> Database Utilities -> Compact and Repair Database...
menu.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.