Why is my access database so large? 83,000KB

[Parker]

Hello,

I have a whopping 5 forms, 5 tables, a few reports and a few more queries... what makes the Access file size so large?

[June7]

Run Compact & Repair and see if that changes size. Run C&R periodically, especially after design modification.

[Parker]

Solved thank you!

[orange]

The rationale for this is that:

-Access uses and manages storage within the database
-when you delete a table or query, you are really marking it as used
-anytime while developing you create, delete, modify an object you are using the space Access has reserved for you and marks it as used
-temporary tables use space; new versions also use space.
Once the space is used or marked used, it is no longer available to be reassigned

It isn't until you run Compact and Repair that Access "cleans up" the used space and frees up space for you.

It is considered a good practice to do Compact and Repair on a regular basis --especially during development.
And you should be doing Backups whenever you make changes to your database.

Glad the size has returned to a respectable value.