ACC2002: View That Is Created from a Linked Server Is Not Updateable in an Access Project (296625)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q296625
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

When you try to update records in a view that is created from a linked server in an Access project, you receive the following status message:
This recordset is not updateable.

RESOLUTION

There are two ways to update records in the view:
  • Update the records programmatically by using ActiveX Data Objects (ADO).
  • Create a stored procedure to update the records in the view.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample project NorthwindCS.adp.
  2. On the File menu, point to Get External Data, and then click Link Tables.
  3. In the Link Table Wizard dialog box, click Linked Server, and then click Next.
  4. In the Select Data Source dialog box, browse to and then select the sample Jet database Northwind.mdb. Click Open.
  5. Click the Customers table, and then click Finish.
  6. Open the Northwind__Customers view that is created, and then try to edit the data.
Note that you receive the message that is mentioned in the "Symptoms" of this article in the status bar.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

281998 ACC2002: How to Bind Access Forms to ADO Recordsets


Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbbug KB296625
©2003 Microsoft Corporation. All rights reserved.