Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

3159 error when running an access query from VB

When I run
    cDBRoutinesInst.ApplicationDB.Execute (sSQLInsert)  
I get a 3159 error. Any ideas? TIA.
0
schoon
Asked:
schoon
  • 3
1 Solution
 
schoonAuthor Commented:
Edited text of question
0
 
schoonAuthor Commented:
Edited text of question
0
 
air3rlrCommented:
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:
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now