Is there a rule to define a primary key on a sql-Server table for access with MS-Access?
- by Ice
Defining some Tables in SQL-Server which will be accessed via ODBC from MS-Access.
I'm not sure about it, put i read somewhere that a primary key must bee named with 'aaaaaPK_ColumnName'.
The 5 'a' should manage that the PK is listed first in the dialog for all key's in MS-Access.
What do you think about that?