Updating data in a linked table is not supported

03 Jan

To accomplish this, you need to be able to analyze the SQL commands that Office Access is submitting.

There are two tools that you can use to see how Office Access is communicating with SQL Server.

In some cases, performance of certain queries degrades to an unacceptable level.

The following number appears in the lower-right corner of this message: 503617Back to the top | Give Feedback WORKAROUNDTo work around this problem, import the text file to the Access database and then run the update query or run the delete query.

Andy Baron November 2006 Applies to: Microsoft SQL Server 2005 Summary: One way to create applications that use Microsoft Office Access for creating user interfaces and that use Microsoft SQL Server for data storage is to link Office Access tables to SQL Server tables.

Any forms, reports, queries, or code that previously worked with the original Office Access tables are automatically connected to the new SQL Server tables.

In an application that uses linked SQL Server tables, two different database engines are at work: the Office Access/Jet database engine that runs on the Office Access client and the SQL Server database engine.