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.