I'm attempting to link an Access 2002 database to an MSSQL server and need to do so without setting up ODBC connections on all user's computers.
I used the code specified in the Microsoft Article ( It pulls in the tables just fine, but I cannot add a new record.
To do so, I have to refresh the links, with an ODBC connection, and specify a Unique Field for the tables. Is there a way to specify this in the code that connects the tables?
Thank you and any help is appreciated.
I used the code specified in the Microsoft Article ( It pulls in the tables just fine, but I cannot add a new record.
To do so, I have to refresh the links, with an ODBC connection, and specify a Unique Field for the tables. Is there a way to specify this in the code that connects the tables?
Thank you and any help is appreciated.