ANSI SQL Features Not Supported in Microsoft Jet SQL
Microsoft Jet SQL doesn't support the following ANSI SQL features:
-
Security statements, such as COMMIT, GRANT, and LOCK.
-
DISTINCT aggregate function references. For example, Microsoft Jet SQL doesn't allow SUM(DISTINCT columnname).
-
The LIMIT TO nn ROWS clause used to limit the number of rows returned by a query. You can use only the WHERE clause to limit the scope of a query.