Tables not updatable

[pleasehelpalot]

I'm new to SQL server. Connected an Access front-end to SQL Server back-end. It seems the tables need to have a primary key to be updatable. One table does not have a primary key and it would not be possible to create one because of the way the table works. Can somene provide more insite for me into what this is about and how to resolve.
Thanks

 

[onpnt]

I can setup Access with linked tables to sql server fine without selecting a unique identifier

have you tried just not selecting one?

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[pleasehelpalot]

The linking of the table is fine, but it is read only and I can not modify, add or delete records.

 

[onpnt]

doh! Some reason I must have not been awake enough to read correctly this morning.

I think you'll have to programmatically do your changes. You would be better off asking this in a access forum though

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[pleasehelpalot]

I think I found the answer. In SQL Serveryou must have a unique field in order to make the table updatable. We created an ID field and populated it programmatically. It worked.
Thanks for you're help. I learned something new about SQL Server and can now move on to the next problem.

 

[SQLBill]

In SQL Serveryou must have a unique field in order to make the table updatable.

Not true. Microsoft ACCESS requires that the SQL Server table has a unique field to be updatable. You can use TSQL on SQL Server to update ANY field even if there isn't a Primary Key or other unique field.

-SQLBill

Posting advice: FAQ481-4875