Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Access changes ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 30413 of 31576
Post > Topic >>

Access changes my query SQL

by jeffatncx@[EMAIL PROTECTED] May 30, 2008 at 10:05 PM

Hi all
ms Access 2003, SP2.
I write a SQL statement that unions some other queries and it works
ok. Then, if I save and close it and open the form that uses the query
as its data source, I get an error that the form can't find some parts
of the SQL that was in my query. I open the query again and find that
Access has changed my SQL, removing some of my code.
Whats up with that?
Is there some way to tell Access to leave my SQL code alone, it works
just fine as I wrote it?

Thanks
Jeff
 




 2 Posts in Topic:
Access changes my query SQL
jeffatncx@[EMAIL PROTECTE  2008-05-30 22:05:08 
Re: Access changes my query SQL
"Allen Browne"   2008-05-31 15:24:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:24:56 CST 2008.