Microsoft Access - Program file keeps growing ?

  tony.r 14:21 04 Feb 03

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.

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

1995-2015: How technology has changed the world in 20 years

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…