Fisrt create DSN to your SQL Server, and create linked tables in Access database via the DSN to SQL Serevr. The linked table name should be same as your original Access table name.
oh my , that's what I long winded wanted to say
All tables in SQL Server should have primary index.
in fact, if they don't have one, Access pops up a screen where you can choose a field from that table. But it is really better to have one.
Btw, Allen, do you know what to do when the Primary index consists of more than one column?
Wenn Englisch zu schwierig ist?