Linking Access tables to SQL Server tables with keys in Binary

[Guest]

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.

 

[david epsom dot com dot au]

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)