Article ID: 219974 - View products that this article applies to.
This article was previously published under Q219974
This article has been archived. It is offered "as is" and will no longer be updated.
When you submit form results to an Excel database, the following error message appears in the browser:
Cannot update the database
Error Description: [Microsoft][ODBC Excel Driver] Operation must use an updateable query.
Error Number: -2147467259
Error Source: Microsoft OLE DB Provider for ODBC Drivers
This problem occurs because FrontPage is connecting to the Microsoft Excel database in a read-only state.
To submit form results to an Excel database, set the read-only attribute of the Excel database connection to not read-only.
To set the read-only attribute of the Excel database connection to not read-only, do the following:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
It is important to set the read-only attribute before you create forms to submit the results to the Excel database. Forms created before you set the attribute will return the error message in the "Symptoms" section of this article.