3159 error when running an access query from VB

When I run
    cDBRoutinesInst.ApplicationDB.Execute (sSQLInsert)  
I get a 3159 error. Any ideas? TIA.
schoonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
air3rlrConnect With a Mentor Commented:
Access is very forgiving and my not always catch Sequel Errors, my suggestion to you is to start small, with one expression at a time and verify that each expression is working properly then nest them as you have above. I have recieved this error when the SQL was incorrect.  Good Luck
0
 
schoonAuthor Commented:
Edited text of question
0
 
schoonAuthor Commented:
Edited text of question
0
 
schoonAuthor Commented:
Thanks for your answer. The problem disappeared later the same day. I don't know why. So long as it doesn't reappear before my contract runs out I'm happy.
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.