3100 : 42000 : [Microsoft][ODBC Microsoft Access Driver] Syntax error. in query expression 'column

I hope my question is underestandable, if not do let me know   I am getting error and how to correct it please advise. Thanks.
Who is Participating?
Make sure you are not using any reserved words (e.g. Date or Password) as column names ... if you cannot change the column names, use [] brackets around them. Ensure that your datatypes are appropriately delimited (e.g. no delimiters for numbers, ' for strings (and dates in SQL Server), # for dates in Access. Also, try to avoid using rs.AddNew / rs.Update -- use a direct INSERT or UPDATE statement instead. This is more efficient and easier to debug.
Mohammad1Author Commented:
-3100 :  42000 : [Microsoft][ODBC Microsoft Access Driver] Syntax error. in query expression 'column
Above is the problem if you could advise me the diagnoses pl. Thanks
Brendt HessSenior DBACommented:
Can you post the entire query?  Ususally, this is either a typo or a misplaced quotation mark.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.