Linking Access tables to SQL Server tables with keys in Binary

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Buster C - 25 May 2005 12:57 GMT

I am using Access 2003 and need to link some tables created in Access with
others imported from an SQL server database. The keys on the SQL tables are
in Binary and although Access appears to retain the Binary data type in
Access I cannot create a Binary key on my Access produced tables to link them.

Reply to this Message

david epsom dot com dot au - 26 May 2005 03:21 GMT

To add an index, use
CodeDB.Execute "Create Index ....

That will allow you to do some things that the Access interface won't
support.

(david)

>I am using Access 2003 and need to link some tables created in Access with
> others imported from an SQL server database. The keys on the SQL tables
> are
> in Binary and although Access appears to retain the Binary data type in
> Access I cannot create a Binary key on my Access produced tables to link
> them.

Reply to this Message