database file size getting larger from search query

[raistlin]

I'm having a problem with my database filesize getting larger with the more searches i do. At first i couldn't figure out how it was getting so big, but then i tried a few things and came to the conclusion that every time i do a search it increases its filezile.

what made me notice this at first is that the file size of the original copy of my db is 13MB, but if i Save As a different name, like Assets_Backup, then the size of the new file is only 2MB, and after i do some searches it increases again.

here is a file with just my search form and search query so you can see the code for them. i removed everything else to shrink the file down, which also made the search form not function properly, but i thought the design and code might be enough.

is there something that i can change to keep it from remembering every search?

thanks for any help.

--------------------
after searching the topic a bit more i've found that compacting the database will shrink it down to 2MB, but is this something that will have to be done on a regular basis, or is there a way for it to do it on its own?

 

[pbaldy]

It is normal for a db to grow due to things like that. Depending on your specifics, a periodic Compact/Repair might be enough, or you can set Compact on Close so it does it each time it's closed.

 

[raistlin]

thank you very much. didn't realize there was an option to compact it when it closes.

 

[raistlin]

this is actually my first database. i'm still very new to access. for the search on my database i came across 2 different search methods that i liked and just combined the 2 to make the one i have now.

could you explain a bit more in detail of what you mean by storing the query as a querydef, or point me in the right direction of what to search for? when i do a search for querydef i get results that just show other people's codes that they're having problems with and doesn't make any sense to me.

here's my db with the search function working in it from one of my other threads if you'd like to see it;

MY SEARCH

i would like to be able to get it so it doesn't continually grow as i search since it will be accessed from a server across our network, but at the moment the compact and repair on close seems to be doing ok.

thanks for you time