We help IT Professionals succeed at work.

Set ANSI-92 SQL query mode in Access 2007

Travis Hydzik
on
4,166 Views
Last Modified: 2012-06-27
experts,

I would like to try using ANSI-92 for my SQL, as I believe it will offer extra features I need.

I have a procedure to convert an existing Access 2003 database to ANSI-92.
http://office.microsoft.com/en-us/access-help/set-ansi-sql-query-mode-mdb-HP003070486.aspx

Can an Expert please tell me how I do this in Access 2007, to my Access 2003 database (.mdb file)

thanks
Comment
Watch Question

Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Travis HydzikVarious
CERTIFIED EXPERT

Author

Commented:
Great!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.