-2

We have an Access database that is currently doing an append query on a table on another database. We have moved all the tables to a SQL Server 2008 database.

The dba used the SSMA tool to migrate the tables to the SQL Server database thus avoiding the use of an ODBC connection. If necessary I could write VBA code to create the link (I have seen an example that I might be able to use).

msrd0
  • 7,816
  • 9
  • 47
  • 82
KevLRay
  • 1

1 Answers1

0

Solved. Found some VBA code that will allow me to create the linked table.

KevLRay
  • 1