MX Release 3.2 (H06.25+, J06.14+)

SQL_ATTR_ACCESS_MODE for Microsoft Access

You can set access mode on the server by defining this environment variable. If you are using the

SQL_ATTR_MSACCESS_VERSION variable, you do not have to set this variable.

• To set the attribute:

◦ In the NSM/web SET tab, the settings are SQL_MODE_READ_WRITE or

SQL_MODE_READ_ONLY.

See “Reconfiguring Server Data Sources” (page 29) for details about using NSM/web

to change settings.

◦ To set this attribute using MXCI in MXCS mode, the syntax is:

CS> add evar <dsname>.SQL_ATTR_ACCESS_MODE,type set, value

‘SQL_MODE_READ_WRITE’;

CS> add evar <dsname> .SQL_ATTR_ACCESS_MODE,type set, value

‘SQL_MODE_READ_ONLY’;

The default setting is SQL_MODE_READ_WRITE and is overridden by the setting from ODBC when

calling the SQLSetConnectAttr function.

If you have set this variable to SQL_MODE_READ_ONLY and ODBC does not override the setting,

update, insert, and delete statements will fail with an error.

78 Using Microsoft Access with ODBC/MX