ACCESS with SQL server syntax




Hello,
I found that ACCESS can be used with SQL server syntax (options).
How to build a valid connectionstring in this case? Jet not valid !? Provider ?
Does this mean that more commands of SQL are available?
Which syntax exactly ? An eaxample with a variable ?
Is it an advantage to use it ?

Thanks very much

Thomas
.