MS Access Update Error

31 Jul 2006 12:57 PM

Jim Heavey

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?

31 Jul 2006 5:37 PM

Paul Clement

On Mon, 31 Jul 2006 05:57:02 -0700, Jim Heavey <JimHea***@discussions.microsoft.com> wrote:

¤ 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)