Introduction - If you have any usage issues, please Google them yourself
The following statement is MsSql statement can not be used in access.
SQL Category:
DDL-Data Definition Language (CREATE, ALTER, DROP, the DECLARE)
DML-Data manipulation language (SELECT, DELETE, the UPDATE, the INSERT)
The DCL- Data Control Language (GRANT, REVOKE, COMMIT, ROLLBACK)