MDB file Size keeps increazing

[tdubs]

Hi all,

I have developed a Access program which import excel tables into the the database and queries some data and writes it into an excel file...

The problem I am having is that after the program is loaded... the file size of my mdb file increase by more than 3 mb..

I tried deleting all the objects in the file.. and the size doesnt reduce at all,
When I import tables, I delete the previous one.. so I don't think it would be that...

The only thing I think the problem mite be is the life line of the variables..

Is it that after I run the program... the Variables stays there and ocupies space...??

afaik, the variables "dies" after the program is finished loading....
if not, is there a way to "kill" the variable at the end of the program?
so far, at the end of the program, I have set my objects = nothing.. to release them... but doesnt seem to help at all

any idea on what this problem mite be??

Thanks in advance..

 

[neileg]

Run a compact & repair. Queries can make the databse bloat and the space isn't recovered until you compact it.

There is a setting which will ensure that you db is compacted on close.

 

[tdubs]

Run a compact & repair. Queries can make the databse bloat and the space isn't recovered until you compact it.

There is a setting which will ensure that you db is compacted on close.

Hi, Thanks So much.. I used the compact on close option...It works perfectly.. the size of the file went from 44 mb to 1 mb...