Module compilation (1 Viewer)

[Ashley Sutton]

Sorry! Last question for today.

I have a "front-end/back-end" application and despite "compiling and saving all modules" the front-end database keeps slowing down and growing in size. When I check I find that the compile and save option is available once again.

How can I prevent this happening?

I did consider creating an MDE version to remove all edittable code from the front-end but since there are several databases linked together and it is not appropriate to create MDE versions of all of them this did not seem to be an option.

 

[Pat Hartman]

Creating temporary databases by using make table queries or creating querydefs in code, or opening forms/reports in design view and modifying them in code will all make the database grow. Access does not reclaim space used by temporary objects until the database is compacted.

 

[Ashley Sutton]

Thanks for the suggestions Pat. I'm sure it is not related to design changes as the problem occurs after all design work has been completed. However there are a couple of Make-table queries in the system which I will check out although running them just now did not produce the problem!