Access database keeps getting bigger

  • Thread starter Thread starter pseudonym
  • Start date Start date
P

pseudonym

Hello,
I have an access database in which I insert 1 gb of data. When I
delete all of the data in the database then insert the data again the
database grows in size by about 90 mb so the total is now 1gb + the
additional 90 mb. Why are there now an extra 90 mb in the databsae?
How do I get rid of the extra 90 mb of data while keeping the 1 gb of
data that I need?

Thanks
Pseud
 
See Compact and Repair Database in Help file (this is under the Tools |
Database Utilities menu in database window).
 
Access like most databases, does not delete data when you delete it, it
only marks it to be deleted. You need to do a "Compact" (see database
utilities) to actually recover the space.
 
You must log in or register to reply here.

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

Aggregate Function Error 0
Access not responding when opening table... 23
Capacity in Access 22
Record-Locking remains open after closing 0
Categorize Continuous Variable into a Discrete One based on a table 1
Not enough space on temporary disk error 13
ACCESS CRASH and MDW format... 3
Upsizing of database 4

Back
Top