Performing Update and Append Queries on Linked Tables in Access (1 Viewer)

jumadenice

New member
Joined
Jun 29, 2010
Messages
3
I have a problem on how to Update and Append data on Linked tables while Using access 2003 as the front end and SQL Server 2000 as the back end linked via an ODBC,

Any time I try I receive an Error

It must be an unpalatable Query

Help please
 

Banana

split with a cherry atop.
Joined
Sep 1, 2005
Messages
6,315
As SQL_Hell indicates, if there's no clear primary key defined for the tables then you can't update. You may need to create a local index which will typically fix the problem. That is especially true when the linked table references a view which doesn't really represent its primary key even if it's selected as a part of the view.

HTH.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom