Hi Laura,
RESOLUTION
To add the primary key or a unique index, use either of the following
methods.
Using SQL Server Enterprise Manager
Click Start, click Programs, click Microsoft SQL Server, and then click
Enterprise Manager.
Locate the linked table in Access.
Right-click the table, and then click Design Table.
To set a primary key, skip to step 10. To set a unique index, continue with
the next step.
Right-click the field that you want to set as a unique index, and then
click Indexes\Keys.
In the Properties dialog box, make sure that the Indexes\Keys tab is
selected. Click New.
Click to select the Create UNIQUE check box.
Click Index.
Click Close to close the Properties dialog box. Skip to step 11.
Right-click the field that you want to set as a primary, and then click Set
Primary Key.
Close the table. When you are prompted to save the changes, click Yes.
Start Microsoft Access.
Open the database that contains the linked table.
On the Tools menu, point to Database Utilities, and then click Linked Table
Manager.
Click to select the check box for the table that you updated. Click OK.
Click OK to the message:
All selected linked tables were successfully refreshed.
You can now update and add new records to the table.
Using Microsoft Access
Start Microsoft Access.
Open the database.
Select the table that you cannot update.
On the Edit menu, click Delete.
On the File menu, point to Get External Data, and then click Link Tables.
In the Link dialog box, under Files of type, click ODBC Databases().
In the Select Data Source dialog box, select the correct data source, and
then click OK.
In the Link Tables dialog box, select the table that you deleted in step 4,
and then click OK.
In the Select Unique Record Identifier dialog box, select a field as the
unique index, and then click OK.
You can now update and add new records to the table.
For Further Information : Microsoft Knowledge Base Article - 304179
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
