Access database keeps getting bigger

[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

 

[Ken Snell [MVP]]

See Compact and Repair Database in Help file (this is under the Tools |
Database Utilities menu in database window).