Search notes:

MS Access: SQL Server Compatible Syntax (ANSI-92)

In Access, SQL Server compatible Syntax (ANSI 92) can be enabled or disabled under the menu File -> Options -> Object Designers -> Query Design

SQL Server compatible Syntax (ANSI 92)

This database
Default for new databases

The SQL compatibility mode (which by default is SQL 89, level 1 can be upgraded to SQL-92 under File -> Options -> Object Designers -> SQL Server Compatible Syntax (ANSI 92):

Changing the option with Visual Basic for Application

With VBA, it is possible to set this options like so:

setOption "ANSI Query Mode", 1

setOption is defined in the Application object. Because this object is the default object, it does not need to be specified.

Index