• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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