Linked Tables

I currently have a SQL Database with 1 Table. I have connected to the SQL table via MS Access 2003 via Linked Tables. I can import records from either an XLS or CSV file to the Link Tables all day. However, I cannot update nor delete records. I have given my account full DBO access to the SQL Database and Table but still cannot make any modification from within Access. Is this even possible for what I am attempting to do within Access? If so, please tell me what I need to modify within SQL. Thanks in advance!I created linked table using ODBC datasource with SQL Native Client provider, it works fine in updating table in SQL2005.|||Access has problems updating linked tables that dont have a primary key defined, as youve imported from an external source and probably dont have a PK defined this may be your problem|||

colinrobinson wrote:

Access has problems updating linked tables that dont have a primary key defined, as youve imported from an external source and probably dont have a PK defined this may be your problem

You took the words right out of my mouth. I had a time trying to figure that out when I was importing some data to my SQL server and trying to edit/delete records. BTW, I was using another SQL server, so this is not just limited to Access.

sql