My Access File Just Became Huge

[Kriis]

I just recently noticed that the database that I have been working on has changed from around 60 mb to 430 mb. I added a few queries and forms. But could that really add to the size that much?

 

[ghudson]

Any changes will enlarge your db. Adding grahpics will bloat the db. Have you compacted it?

 

[Kriis]

Just to check...I made a copy of the database and deleted all the tables, forms, queries in it....and it's still 435 mb.

How can this be?

 

[FoFa]

Search the forums, you will see that access does not automagically shrink itself.

 

[ghudson]

Just to check...I made a copy of the database and deleted all the tables, forms, queries in it....and it's still 435 mb.

How can this be?

Again... Have you compacted your database?

 

[Kriis]

I see. But I still don't understand where the almost 400 mb came from. I didn't add any graphics or sounds. I just added a couple forms and drop down menus.

 

[FoFa]

Did you run any queries? Did you create ant large record sets? Did you run multi-queries (queries based on other queries)?

 

[Kriis]

Again... Have you compacted your database?

Sorry...no I haven't. I don't know anything about compacting databases.

 

[FoFa]

Here, check THIS link for more information.

 

[Kriis]

Thank you guys!

Wow...compacting makes a big difference. Went from 435 mb to 19 mb.

Sorry for the stupid question. I didn't even know this utility existed.

Thanks again!