UNique Record IDentifier not popping up

[anthonys]

When i link a SQL table to MS Access using ODBC the UNique Record IDentifier is not popping up.

Does anyone know a way i can manually set this, or force it to pop up, as at the moment i can't add any records to my database?

Thx in advance

Ant

 

[HiTechCoach]

Did you select the correct primary key field when link the table?

 

[boblarson]

And another thing to investigate - does the SQL Server table have a primary key assigned?

 

[anthonys]

Did you select the correct primary key field when link the table?

- The problem is that the pop up box to select the primary key is not popping up.

And another thing to investigate - does the SQL Server table have a primary key assigned?

- The primary key in SQL is a unique Rowid but it still is not working

 

[anthonys]

Fixed problem by recreating the ODBC connection and reinstalling ODBC drivers, thanks for all your help!