Database is growing without any new data

[sodakotahusker]

I have a client who is using Access to access SQL server tables. He says that whenever he opens and closes Access, the size of the .mdb file grows - perhaps doubling its size. He said he tried to repair it and that took it down to 53 meg. However the problem continues. It's gotten up to 1.5 gig. Anybody have a clue what is going on here?

 

[MoLaker]

He may have a "make table" query or some procedure that creates temporary objects. Any objects created will increase the size of the DB even if they are deleted. The only way to remove them entirely is to compact the DB. Ask a lot of questions, as there is probably more going on than just "whenever he opens and closes Access, the size of the .mdb file grows".

"Retired Programmer". So, please be patient.

 

[JerryKlmns]

That goes also for importing processing and then deleting records!