Database SIze

[dvannoy]

I have a database that's still in development. a couple of days ago the size was about 25mb...Now it just jumped to 75mb...any reason??? I have not added that much more to it.

Is there a way to decrease the size without compacting it??

Thanks

 

[jimstay]

The "wonders" of Microsoft. They just grow every time you update anything, with almost no relationship to the amount of data. Just compact it, and it will go right back to teh original size.

Jim

 

[Guest_imported]

I have had this problem in the past. Try opening a blank DB next to your open DB. Point and drag everything...tables, queries, forms, reports, macros, modules... You may have to re-establish your relationships (can't remember if you can drag and drop them) but you will see the size of your database drop dramatically. Every time you try something new Access adds it to the SQL section of the DB. If you delete and item it does not delete the SQL statement therefore it keeps building up. Without data most Access DB are not really that big! It's all the trial and error that begins to ADD UP! Try this... the worse thing that can happen is you waste a little time.

MACarter

 

[rnc110]

Just compact and repair it "Tools Menu then Database Utilities".
You need to do this two times in a row in order for it to work properly