Database Size?

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have a "front" database merely contains, forms,
queries, report and macros. The tables are all linked in
another "back" database.

The "back" database with the tables is naturally growing
in size, but I alarmed at the size of the "front"
database which in effect doesn't have any data.

Can anyone shed some light on why this is so and how I
can stop this happening, the "front" database is now 52mb
big.

Rob
 
A front-end database can grow if you are programmatically creating queries
or have temporary tables or the like. It depends a great deal on what the
FE is actually doing. Do you compact regularly? Do you modify the FE
regularly? That can also lead to bloat.
 
Rob,
If you are using Access 2000 or above, you must MANUALLY compact the
database
(as opposed to compacting it programatically) in order to compact it
completely.

My advice:
1.) Compact the front-end using the Access menu
2.) Compact the back-end (you should do this regularly)
3.) Convert the .MDB front-end into an .MDE front-end.
(This is done via the Access menu - near the "Compact"
feature
4.) Do NOT convert the back-end into an .MDE file
---Phil Szlyk
 
Back
Top