Visual Basic Q&A

Symptoms
In systems that do not have MDAC 2.1 installed on them, when you use the FoxPro ODBC ISAM Driver (named “Microsoft FoxProDriver(*.dbf)” in the ODBC Administrator) for 2.5 or 2.6 tables, it allowsyou to view the contents of a table created in Visual FoxPro. However, whenyou try to update or add new records, the following error message mightappear:

Operation must use an Updateable Query.
Resolution
The older ISAM driver is not able to accurately read the table header ofthe Visual FoxPro table. Visual FoxPro supplies additional information inthe header of the table for links to a database container, which the olderISAM ODBC driver does not accommodate. Snapshot recordsets are updateableas long as the table is in 2.5 or 2.6 format.

Symptoms
When you edit an Excel worksheet through ADO and ODBC, you may receive the following error message if you use an ADO DataControl object:

[Microsoft][ODBC Excel Driver] Operation must use an updateable query.If you use a Recordset object that is generated with ADO code, you may receive the following error message when you edit an Excel worksheet through ADO and ODBC:

Run-time error ‘-2147467259(80004005)’:[Microsoft][ODBC Excel Driver] Operation must use an updateable query.
Resolution
This problem occurs if you try to edit a worksheet that is saved or opened as ReadOnly.
NOTE: ReadOnly is the default setting for an ODBC connection to Excel, with or without a data source name (DSN). Therefore, the user must always change that setting to edit data.