ODBC link to SQL Server

G

Guest

When linking certain tables to SQL Server programmatically via the VBA
command DoCmd.TransferDatabase, the tables link correctly. However on linking
the user is prompted to "Select a Unique Record Identifier" to ensure data
integrity. The table fields are provided. Is there a way to automate this ie
provide the required information as part of the DoCmd.TransferDatabase
statement?
 
V

Van T. Dinh

Do you have a PrimaryKey defined on the SQL Server Table?

I tested the TransferDatabase code in Access 2003 to an SQL Table with PK
(and TimeStamp Field which is recommende if you link the Table to Access)
and Access linked thee Table correctly without asking me to select a Unique
Record Identifier.
 
V

Van T. Dinh

Sorry if it is a bit hard to read ... I think I need to replace my sticky
keyboard or my fingers or my brain ... or all three?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link from SQL server 1
Setting Primary Key on a Linked SQL Table 4
Linking Files and Select Unique Record Identifier 2
Select Unique Record Identifier 2
Importing Table from ODBC 2
linking to server view problem 3
DoCmd.TransferDatabase acExport to SQL server 2005 2
Link Tables to SQL Server DB - Unique Record Identifier 4

Top