Database Size

[Gary_Mc_Mahon]

Hi,

I have a databas which records many status' and dates for progression of an order. There is an imput form the users input through.

Each time this form is opened the database size increases by 5M, any ideas what I'm doing wrong and how I can keep the size down besides compacting the database.

Cheers,
Gary

 

[SydneyGeek]

Sounds weird, unless you are continually deleting and/or creating queries or other database objects when you open the form. In my experience, changing the database structure can cause size blowouts but just adding records is not usually a problem.

Denis

 

[Andrew Fergus]

How big is your database before you compress it? Also, how many indexes are there in the underlying data table(s) that is / are being accessed through the form?
Andrew

 

[Gary_Mc_Mahon]

Before I compact there it can jump up to 300M, then down to less than 2 when compact.

I have many drop down combo boxes with underlying data in several tables but the main form data feeds into three different tables with each filed having an on update procedure to track all changes made by the users.

Hope this helps.
Gary

 

[SydneyGeek]

Following on from Andrew's comment -- maybe the multiple combos are causing you problems (the data fields that they use are indexed). If those fields change regularly, you'll be rebuilding indexes and bumping up the database size.

EDIT -- This article from Microsoft KB says that changing SQL statements will increase DB size http://support.microsoft.com/default.aspx?scid=kb;en-us;165823
This article says that using DAO can be a problem http://support.microsoft.com/default.aspx?scid=kb;en-us;197953

Maybe they'll point you in the right direction

Denis

 

[Gary_Mc_Mahon]

Thanks for the pointers Denis, I'm not sure what I can do to get round this problem. Any obvious suggestions I'm missing?