.mdb File not growing in size

[Trip]

Hello all,

I'm a bit concerned as I have an Access dB which for some reason,
despite collecting data all day every day, the file size has remained
constant at 151,660 KB for the last three days.

The largest table has 1.885 million rows (and growing).

Am I pushing Access too far? I'm using MS Access 2002 (10.2627.4219)
SP-2

Any direction or feedback you may have would be greatly appreciated!

TIA,

Trip

 

[J]

Maybe your file has a lot of rows marked for deletion that are getting
slowly overwritten. When no one is using the database, open it and
try:

Tools->Database Utilities->Compact and Repair Database

This should reduce the size of your database to its minimum. From then
on, as rows are added and queries are run, it should grow in size. Of
course, overtime stuff will be marked for deletion again and it will do
the same thing. If you can confirm my theory with this, then you have
nothing to worry about. Just run 'Compact and Repair' every so often
to keep the filesize down.

~J

 

[Guest]

Has the database been split into a back-end/front-end? If the data resides
in a back-end MDB file, and the front-end MDB file is not running a lot of
queries and reports, then your file (assuming it's the front-end) would not
expand in size. Additionally, if the front-end is set to compact on exit
then you wouldn't notice any increase in size either, unless you created new
reports and/or queries.