Monday, June 28, 2010 8:51 AMI’m trying to link to access 2003 a table from SQL server via an ODBC connection. When doing so, I get a popup to select the unique record identifier. Note that the table itself has no primary key but could have an index. However, we can disregard it without choosing a unique record identifier but the linked table cannot be updated in any way from Access. Please advise
Monday, June 28, 2010 1:37 PM
You must have a unique (primary) key on a table in order for Access to be able to update the data. If you don't, Access cannot tell SQL Server which row you are trying to update.
Depending on the definition of the table and the data stored in it, you may be able to define a primary key based on the existing columns. Alternatively, you may need to add an extra column (such as an Int Identity - equivalent to an Autonumber field in Access) and then make that the primary key.
Simon Jones http://pcpro.co.uk
- Marked As Answer by Jennifer Zhan Monday, July 05, 2010 1:44 AM