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.
Mohammad1Asked:
Who is Participating?
 
Programming_GalCommented:
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.
0
 
Mohammad1Author Commented:
-3100 :  42000 : [Microsoft][ODBC Microsoft Access Driver] Syntax error. in query expression 'column
SELECT *'.
Above is the problem if you could advise me the diagnoses pl. Thanks
0
 
Brendt HessSenior DBACommented:
Can you post the entire query?  Ususally, this is either a typo or a misplaced quotation mark.
0
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.