SQL transformation modes affect the way the access service modifies SQL statements that are written for one database but are processed against another.
When you configure the access service with a specific transformation mode, that mode is effective for all client connections unless you use a set statement to alter it for a specific connection.
To make dialects appear as common SQL, the access service supports passthrough and sybase standard transformation modes.