[ODBC Microsoft Access Driver]Optional feature not implemented

Hi
I have a strange error. I have a java application, connecting to a MSAccess database. When I do a SQL statement that tries to update the following:
"update consultant set name = 'checking for UPDATE' where (consultant_id = 1)"
I get the following error:
"[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented"
But if I change the string to be updated, to say:
"update consultant set name = 'checking xxx UPDATE' where (consultant_id = 1)"
It updates with no problems.
I presume that 'checking for UPDATE' is a reserved string. But why can't I update this string to the database? It is enclosed in quotes.
Does anyone have any explanation/resolution for this?
I have an JDBC/ODBC bridge connection to a MSAccess 2002 database using the following driver: "Microsoft Access Driver 4.00.6019.00" set up in Windows XP's ODBC Data Source Administrator.
I Use the following DriverManager: "sun.jdbc.odbc.JdbcOdbcDriver" and ConnectionString: "jdbc

dbc

atasource_name" where "datasource_name" is the name of the ODBC datasource.

i've too faced the same problem with Access database & what i've figured out is that "Optional feature not implemented" means there is some SQL error (SQL that is not supported by Access is being used).....i really can't figure out why this error occurs, but since FOR is a keyword in SQL, it could be a problem (but then again, you've enclosed it in quotes)...
try using the same using Oracle or some other database & if it works, then Access is the cause for your error....else we'll just have to wait for some of the gurus to clear this doubt...!

Itried MS SQLServer and I don't get the problem. Also when I run the SQL statement in the MSAccess SQL worksheet directly I get no errors. This leads me to think it is an error with the ODBC driver.
Any Ideas?

hi,
i did some searching on the net & what i found out was that it's an error returned from your ODBC driver. Here is a link direct from Microsoft
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odch15pr_6.asp
don't blame me if you don't understand what's written there.....
one guess is that the datatypes in your database & your call to the executeQuery method might not match, you haven't given all the required fields (even fields which can be left blank in the DB have to be supplied to the ODBC driver, great work Microsoft!)
let me know if your problem gets solved.

Tried the above and used a BigDecimal instead of a long (despite the fact that it's a long in my access database (get Bill Gates in here) and it worked.