Linked table From SQL Server

[accessman2]

Hi,

I used ODBC to link the tables from SQL Server to MS Access.

When I link the table, it popup the message:

Select Unique Record Identifier

To ensure the data integrity and to update records, you must choose a field or fields that uniquely each record. Select up to ten fields.

It force me to set up at least 1 field for primary key in a table.

How can I skip it? I do NOT want to setup primary key of the fields in a table.

Please let me know, thanks.

 

[FoFa]

Without a unique identifier, Access will not allow you update the table data then.

 

[RV]

Without a unique identifier, Access will not allow you update the table data then.

Shouldn't that read that SQL Server requires to use unique identifiers on tables?

Rv

 

[FoFa]

Shouldn't that read that SQL Server requires to use unique identifiers on tables?

Rv

Actually Sql Server does NOT require unique identifiers. BUT a linked table in access requires a unique identifier on the SQL Server table before it allows you to make changes to the underlying linked table.
How ever what does suprise me about Access, is if you have a unique index on a Sql table, Access still askes you for the unique field. It should know you have a unique key.