Microsoft KB Archive/296625

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

Article ID: 296625

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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 &quot;Symptoms&quot; of this article in the status bar.

