run-time error 3078 when using DoCmd.TransferDatabase acLink with linked tables

Question

Hi,

I have 2 access database:

• Access database B contains linked tables towards an SQL Server Database
• Access database A tries to link the linked tables from B.

I do this using this code in access A:

DoCmd.TransferDatabase acLink, "Microsoft Access", "c:\myaccessB.mdb", acTable, "MyTableName", "MyTableName"

This is the error I get:

Run-time error '3078'

The Microsoft Access database engine cannot find the input table or query MyTableName. Make sure it exists and that its name is spelled correctly

This code works fine with tables that are local in access database B, but not on linked tables.

Anybody has any idea?

Thanks a lot i nadvance, and kind regards,

Pieter

Answer 1

You can't link to a linked table; you have to link to the SQL Server tables directly.