ODBC link to SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AlanC - 06 Nov 2006 08:32 GMT

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?

Reply to this Message

Van T. Dinh - 06 Nov 2006 10:40 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

> When linking certain tables to SQL Server programmatically via the VBA
> command DoCmd.TransferDatabase, the tables link correctly. However on
[quoted text clipped - 4 lines]
> provide the required information as part of the DoCmd.TransferDatabase
> statement?

Reply to this Message

Van T. Dinh - 06 Nov 2006 11:11 GMT

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?

Signature

Van T. Dinh
MVP (Access)

> 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.

Reply to this Message