C
Carlo Razzeto
Hello, I am under taking my first project that will use MS Access as it's
back end data store. The project was originally written against SQL Server
and worked happily but the client suddenly wanted to switch to Access (don't
ask me why because I don't know). Anyway, here is my problem... I am writing
an object that I will use as my authentication token on my web page. The way
it works is when you instantiated it, it connects to the database, queries
the tables for the data it needs, then closes its database connection and
cleans up after its self. That part of the project ported just fine and
works great, the problem I'm having is with a method of my user object that
updates user information. Even though my update query appears to be correct,
it's throwing a OleDbException loaded with the error "Syntax error in UPDATE
statement.". Here is the query that is being sent to the datase:
back end data store. The project was originally written against SQL Server
and worked happily but the client suddenly wanted to switch to Access (don't
ask me why because I don't know). Anyway, here is my problem... I am writing
an object that I will use as my authentication token on my web page. The way
it works is when you instantiated it, it connects to the database, queries
the tables for the data it needs, then closes its database connection and
cleans up after its self. That part of the project ported just fine and
works great, the problem I'm having is with a method of my user object that
updates user information. Even though my update query appears to be correct,
it's throwing a OleDbException loaded with the error "Syntax error in UPDATE
statement.". Here is the query that is being sent to the datase:
