Access changes my SQL queries

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

Hi,

I'm writting some complex SQL queries and, since the
wizards create poor performance code, I like to write them
myself. Has an example, some queries I wrote run in about
10 seconds, when Access created code takes several minutes
to acomplish the same results.

The problem is that when I reopen the database, Access
does some "cleanning up" and changes my queries, leaving
me with the same poor performance code I would obtain by
using Query Designer.

The question is: how can I turn off, if possible, this
automatic changes?

Thank you.
 
Dear Andre:

Bad news. It cannot be turned off.

Keep a separate set of text files using Notepad or another text
editor. These can be your "real" queries, and you can paste them in
every time after you modify them. This way, you can keep your queries
looking the way you want them.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top