I have a query that uses three tables, and a form based upon it that is very complicated, multi-tabbed and sub-formed. The form was running quickly and smoothly until one day I decided to try adding a table to the main form's query, and calculating the number of entries in that table per each master record--I was going to use this is in the main form. It slowed things down so much, however, that I got rid of that table from the query--but when I went back into the form it still took forever to load and change records. I spent an entire day trying to figure out the problem, until finally I narrowed it down to the query. Luckily, I had an old version of the query in a backup copy of the database, and after deleting the current version and restoring the old one, everything was fast and fine again. What was going on? To my eyes, in design view everything was the same between the two queries.
This is also not the first time such mysterious behavior has occurred in Access. Earlier on, the very same form was incredibly slow, and that time it turned out to be because of a different unnecessary table being linked in the query (by a letter code, actually). When I deleted the table from the query, the form stopped working, even though I could find no reference to the fields I had deleted. I made a new form from scratch, and it worked fine, and much quicker. Why did this wierd stuff happen? Has anyone else run into problems like I described? Are there such things as phantom fields remaining in queries or forms even after they're deleted?
This is also not the first time such mysterious behavior has occurred in Access. Earlier on, the very same form was incredibly slow, and that time it turned out to be because of a different unnecessary table being linked in the query (by a letter code, actually). When I deleted the table from the query, the form stopped working, even though I could find no reference to the fields I had deleted. I made a new form from scratch, and it worked fine, and much quicker. Why did this wierd stuff happen? Has anyone else run into problems like I described? Are there such things as phantom fields remaining in queries or forms even after they're deleted?
