Database Size?

[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

 

[Roger Carlson]

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.

 

[lbrinkman]

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