Linking Access tables to SQL Server tables with keys in Binary

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
 
Back
Top