db grows from 2,000 KB to 1.1 MB !

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

Hi all. After compacting my dB it is about 2000 KB.
After running my code module it is over 1 MB. My code
module does alot of adding and deleting rows in existing
tables, and very little adding and deleting tables. What
type of operations make the dB get so big and what steps
should I take to reduce this problem? Thanks in advance.

Andy
 
Check the properties in your queries. Set Use
transactions to NO. See how that goes.

However, this results in you loosing the ability to do a
roll back !!
 
thanks gary.
i am assuming that transactions are not being used since i
have no BeginTrans or CommitTrans methods being called.

andy
 
Andy,
I've run into similar problems in the past. As I
understand it when Access performs deletes it clears the
data but does not give back the disk space used to store
the data. So a process that adds and then deletes alot of
records will be about the same size as if you just added
data without the delete. Perhaps you can perform the
compact at the end of your module.
Steve
 
Back
Top