Access database getting error for one user

Question

I have an Access database that works perfectly fine on three computers, but one user gets this error message when she tries to save the data:

DoCmd. RunSQL vsql

Does anyone know why only one user would receive this error message when the Db runs fine on other computers?  Thank you!

Answer 1

So the problem is with whatever the value of vsql is at the time that code is run. 

What you need to do is put the line Debug.Print vsql in front of the line that is throwing the error and run the code again. when it errors, hit Debug and Immediate Window should show the SQL statement. Copy and paste that into a response here so we can see if we can spot the problem.

Answer 2

Hi. Can you post the complete code? Thanks.

Answer 3

When I click debug it takes me to that line of code. Sorry for the confusion.  I know nothing about coding or access and the person who wrote this database is no longer working at our company.

Answer 4

Run-time error 3134

syntax error in INSERT INTO statement

Answer 5

That's not a message that's a VBA line of code. What is the message she is getting? What is the value of vsql when that line of code is executed? Is the database split?