MDB Constantly Expanding

[Posse John]

I have a front-end application that users input data, the data then is
transferred to a back-end DB.

My application keeps growing for unknown reasons. In the program, many
memory variables are used.

Do I need to release them prior to program exit?

Whatelse might be causing my file to 'grow'?

 

[MikeJohnB]

Google for Database Bloat

The database bloats without any relationship to the data stored, Access 2002
has a particular problem that you might find information on here.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;810415

Regularly Compact the database by selecting

Tools\database utilities\Compact and Repair Database.

You can also set tools options to compact on close

Hope this helps

Mike B
--
An Engineers Prayer:
At the very end of the day,
when all else fails,
you have tried all,
you have shouted at and blamed the innocent,
and asked everyone you know,

READ THE INSTRUCTION MANUAL.

 

[Tony Toews [MVP]]

I have a front-end application that users input data, the data then is
transferred to a back-end DB.

My application keeps growing for unknown reasons.

How big is big? How many Mb is the file now and how much bigger does
it get on a daily/weekly basis? If the growth on the first day is
less than 20% and about 1% or 2% thereafter I wouldn't worry about it.

Just ensure you compact regularly such as monthly or so.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm