-2147467259 - Operation must use an updatable query

From Support

If you have a question or seek clarification, please call Technical Support.

Problem:

The "Operation must use an updatable query" error occurred when trying to insert a record into an MS Access database.

Solution:

This was a bogus message. We made sure that the ODBC data source was not read-only, which is the usual reason for this error. The real problem was a syntax error in the INSERT statement, namely, that there was no blank before the VALUES keyword.

C                   Eval      Rtn = SQL_RunSQLExec(SQL_Socket:
C                             'insert into NameAddress' +
C                             '(First)' +
C                             'VALUES(' +
C                             quot + 'James' + quot )')

Note that in the 3rd line there is no blank after the right parenthesis, so the statement looks like

"(First)VALUES("

at that point. The source should be

C                   Eval      Rtn = SQL_RunSQLExec(SQL_Socket:
C                             'insert into NameAddress' +
C                             '(First) ' +
C                             'VALUES(' +
C                             quot + 'James' + quot )')

which will result in

"(First) VALUES("

This article has been proofread by Jordan as of 11:00, 9 April 2007 (Central Daylight Time)