The reason is that when you're connecting with a mdb file using the Jet driver, you're actually not dealing with an Access database, but with a Jet Database Engine, and there some minor differences in the SQL. For example, in Access, the Wildcard character
is *, in Jet it is %. Also, you cannot uses a few of the build in functions, Like Replace and Nz. And the list of reserved words is also different:
hans_v
All-Star
35998 Points
6551 Posts
Re: Syntax error in INSERT INTO statement.
May 25, 2012 09:40 AM|LINK
The reason is that when you're connecting with a mdb file using the Jet driver, you're actually not dealing with an Access database, but with a Jet Database Engine, and there some minor differences in the SQL. For example, in Access, the Wildcard character is *, in Jet it is %. Also, you cannot uses a few of the build in functions, Like Replace and Nz. And the list of reserved words is also different:
List of Reserved Words in Access
List of Reserved Words in Jet
You need to show your SQL?