Access changes my SQL queries

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.
 
T

Tom Ellison

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query links to SQL server and mdb table 1
How to Change criteria on a saved query using VBA 0
Problem with queries and linked SQL Tables 2
Update Table Field Value with SQL Query 2
Query on SQL Server is fast, while Access is crawling 2
nesting queries - best practice? 2
In Access 2010, how do I create a SQL query? 1
Update pass through query of report recordsource 2

Top