Db Bloat in Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is anyone aware of what causes rapid and excessive db bloat in Access 2002?
We have a secured application that is correctly separate from the back-end
db. There are no queries or other code running in the back-end db. The data
was repaired and compacted on Feb 17th; at that time the db was 1.5 mg. Ten
days later the db was 10 times bigger; 282 records have been added and about
30 more have been edited - this is not extraordinary volume. This wasn't a
problem with Access97. Any clues?

Thanks
 
Hi Kristie,

Check out the various KB articles referenced by this TinyURL that I have
bookmarked:
http://tinyurl.com/2dmpw

Are you opening any recordsets and then not closing them & setting
references = nothing at the end? Are you creating temporary tables? If so,
are you using DAO code or SQL DDL code to create the temporary tables?

Manipulating Objects with DAO May Cause Database Bloat
http://support.microsoft.com/?id=197953


Tom
http://www.access.qbuilt.com/html/expert_contributors.html
___________________________________

:

Is anyone aware of what causes rapid and excessive db bloat in Access 2002?
We have a secured application that is correctly separate from the back-end
db. There are no queries or other code running in the back-end db. The data
was repaired and compacted on Feb 17th; at that time the db was 1.5 mg. Ten
days later the db was 10 times bigger; 282 records have been added and about
30 more have been edited - this is not extraordinary volume. This wasn't a
problem with Access97. Any clues?

Thanks
 
Back
Top