Query editor (changing format)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Eveyone know that access may change your SQL query syntax when you save your query. This is really frustrating when you're working with a multi-line query and need to edit it in the futur

I used to save a backup copy of my query in notepad for later use

Anyone has a better solution to prevent access from changing my SQL query. Is there a third party add-in that allows me to create a query without access changing it

I was thinking about creating such an add-in and storing all my queries in a table and refering to it for later use, instead of using notapad

Any help would be appreciated

Thanks !
 
A table with a memo field to store your SQL statement sounds perfect. No
add-in needed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Martin Deschenes said:
Eveyone know that access may change your SQL query syntax when you save
Click to expand...
your query. This is really frustrating when you're working with a
multi-line query and need to edit it in the futur.
I used to save a backup copy of my query in notepad for later use.

Anyone has a better solution to prevent access from changing my SQL query.
Click to expand...
Is there a third party add-in that allows me to create a query without
access changing it ?
I was thinking about creating such an add-in and storing all my queries in
Click to expand...
a table and refering to it for later use, instead of using notapad.
 
Back
Top