Siegfried Heintze wrote:
Tim says @@IDENTITY works with ADO and but not DAO. What about ODBC?

Tim meant that @@IDENTITY is supported when using the Jet 4.0 OLE DB
provider with a Jet 4.0 database.

Tim says there are a lot of TSQL features supported in MS Access. Is there a
list somewhere?

The new features for Jet 4.0 were intended to bring Jet more in line
with SQL Server:

Description of the new features that are included in Microsoft Jet 4.0
http://support.microsoft.com/default...b;en-us;275561

OLE DB Provider for Microsoft Jet: SQL Support
http://msdn.microsoft.com/library/de...pe_support.asp

Will these fancy keywords like CASE and ROLLUP work in MS Access?

AFAIK Jet has no CUBE (GROUPING, ROLLUP, etc) support but there may be
workarounds?

CASE is implemented in Jet using IIF() and/or SWITCH() constructs you
could look them up in the help ...

There used to be MSAccess SQL syntax at search.microsoft.com but I cannot
find it

.... but I'm pretty sure there are is no official documentation listing
which functions are supported/enabled in Jet. Basically, it is the VBA5
functions which return a single value, distinct from methods or
functions which return arrays etc. And I know CDec is broken
(http://support.microsoft.com/default...;en-us;Q225931),
grrr! Brendan Reynolds MVP has been compiling a list:

http://brenreyn.blogspot.com/

If you want the Jet 4.0 language documentation, try he

http://office.microsoft.com/en-us/as...526881033.aspx