Unique Record Identifier

[JimP]

When linking a SQL Server table manually, a "Unique Record Identifier"
window pops up, requesting a selection of fields to uniquely identify each
record.

Is there a way to do this via code? I don't see any place in a
"DoCmd.TransferDatabase" command that appears to accept such arguments.

 

[Roger Carlson]

If there is a unique identifier (primary key) set on the SQL Server table,
you shouldn't get this dialog box.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L