Microsoft Access - Program file keeps growing ?

  tony.r 14:21 04 Feb 2003
Locked

I have two problems. I have an access database split into data and programs. Some of the forms are based upon tables but also have a command button to apply a filter, run a query or sort the displayed data into a new sequence.

Problem is when the form has been opened and a query run. It seems that the next time that form is loaded it retains the previous query so rather than displaying all of the records in the underlying table it just returns a sub set.

Also the program file is continually increasing in size. I presume because these retained queries are causing the forms design to be updated.

Has anyone come accross this? This seems to be the case on both Access 97 & 2000

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?