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

[jumadenice]

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

 

[SQL_Hell]

No primary key?

 

[Banana]

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.

 

[SQL_Hell]

Sorry, bit vague. Cheers for the explaination of my question