Huge size increase in mdb file

[Michael W]

I have an Access 2000 application utilizing a front end mdb file for the
forms, queries,reports and modules and a back end mdb file that contains only
data tables. Both mdb files are located on an NT 4.0 server. My problem is
with the back end data file.

The normal size of the data mdb file after a compact is 22 mb. Over a two
week period it typically increases to about 28 mb at which time I compact
again. Last Friday in four hours it increased to 750 mb!

While testing, after a compact, I had a user add one record and as soon as
she made a selection from a dropdown box in the first field the file size
jumped by 14 mb to 36 mb (a 64% increase). I have been able to duplicate this
behavior when adding records to two other tables.

I have created a new mdb file and imported the tables with the data but this
did not solve the problem.

What could be wrong that could cause the file size to increase by 50% by
adding one small record?

 

[Jesper F]

What could be wrong that could cause the file size to increase by 50% by

adding one small record?

Are you storing blob data i.e. images, video or sound as OLE-objects in the
database?
This severely bloats the database.


Jesper Fjølner, Denmark

 

[Michael W]

No video, sound, or graphics. Closest I come to that are a couple of memo
fields.

 

[MIKemp]

Michael

Check out the tables and ensure that all text and memo fields are set to use
unicode compression.

Up to '97 this was the default but thereafter the default is 'No'

Michael K