Database Size Increase

[Sandpiper]

Hi
I'm having problems with a database that is increasing in size simply by opening and closing it.

I've read through the many posts on here about that, and looked through the code for open recordsets and queries etc, but can't find anything that looks like it is causing it.

This is a database that i acquired and have modified to suit various businesses, and so it has been used several times and isn't happening in any other instance. The only thing that is different about this one is that it runs using a runtime licence. However, the size increase still occurs when I run it on my laptop.

I open a form which shows a list of Clients, when you click on the name, the full details populate the remainder of the form.

Just by clicking on a couple of names, then closing the form and the database, the size increases by between 50 and 200ish mb.

Can anyone think of anything I should be looking for to stop this happening, or could it be something to do with the runtime?

Any help would be much appreciated.

Thanks
Jo

 

[boblarson]

Most likely it has to do with however the client list is being populated. Are there any "make table" queries happening? That is a big bloat maker.

 

[Sandpiper]

Hi, sorry for not replying sooner.
There are a couple of make table queries, but they aren't having the same effect in other companies. I use the same base database for several companies and just make a few minor adjustments to suit the client.

Thanks

 

[Pat Hartman]

Do you happen to have compact on close set on the ones without problems and not set on the one with the problem?