[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Set ANSI-92 SQL query mode in Access 2007

Posted on 2011-04-20
Medium Priority
Last Modified: 2012-06-27

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.

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

Question by:thydzik
LVL 23

Accepted Solution

OP_Zaharin earned 2000 total points
ID: 35438593
hi thydzik,
- to switch to ANSI-92 in Access 2007:
: open Ms Access
: click the Office button on top left
: click "Access Options" button
: select "Object Designers" from the left pane
: look for "Query Design" section, there is an option "SQL Server Compatible Syntac (ANSI 92).
: if you have an open database, you can check on "This Database" or check the "Default for new databases" for default setup on all new databases
: click "OK" button to accept the changes
LVL 11

Author Closing Comment

ID: 35438822

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question