MS Access Update Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I attempt to do an updated to a MS Access Database, I get the following
Error Code returend "-2147217900". The error message says "syntax error on
insert statement", but I can paste that SQL into Access and it works just
fine.

Research on the WEB indicates that this is a permissions issue and they
indicate that I must go in an grant access to the "IUSR_XXXXX" where "XXXX"
is the machine ID. I did this, but I get the exact same results.

Any Ideas?
 
¤ When I attempt to do an updated to a MS Access Database, I get the following
¤ Error Code returend "-2147217900". The error message says "syntax error on
¤ insert statement", but I can paste that SQL into Access and it works just
¤ fine.
¤
¤ Research on the WEB indicates that this is a permissions issue and they
¤ indicate that I must go in an grant access to the "IUSR_XXXXX" where "XXXX"
¤ is the machine ID. I did this, but I get the exact same results.

You may have to post the SQL statement. My guess is that you're using a reserved word in your SQL
statement which Access is typically able to revolve without an error.

Remember you're executing the SQL in different environments so I wouldn't necessarily expect the
same results.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top