I have been using DoCmd.TransferDatabase... to link to an SQL Server. Usually what I do is delete the table first and then use this command. Most of the tables have a Primary Key and it works fine. However, there are some tables that do not have a Primary Key designated and I get the "Unique Record Indentifer" pop up window, click OK and it continues on. I would like to know if there is a way around having this window come up? Is there something that I can add to DoCmd.TranferDatabase line to automatically do this for me or another command. Locally I do not have access to change anything on the SQL Server Database.
Thanks.