Can you Link a table in one DB to another DB's linked table?

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

Guest

I have an existing application written in MS Access using a number of databases.
It has the usual forms, queries and reports.
The client wants the front-end left as is and the data moved to a backend SQL Server.

Currrently:
MSAccess DB1, Table1 is a linked table to MSAccess DB2, Table2

If I upsize DB2, Table2 to SQL, I can no longer link from MSAccess DB1, Table1 to MSAccess DB2, Table2_SQL. (The new link from MSAccess DB2, Table2_SQL to SQL does work). And, no, I do not want to modify the front-end to go directly to the backend SQL.

In otherwords, it looks like you are not allowed to link to a linked table. Is this true?
Is there a workaround? I do not want to change the front-end DB1 as it is on hundreds of desktops.
 
Hi,

You can not link to a linked table. You have to link directly to the source.

Do you not perform updates/enhancements to your front-end DB1 and distribute
it the the users' desktop?



HTH,
Immanuel Sibero



Paul said:
I have an existing application written in MS Access using a number of databases.
It has the usual forms, queries and reports.
The client wants the front-end left as is and the data moved to a backend SQL Server.

Currrently:
MSAccess DB1, Table1 is a linked table to MSAccess DB2, Table2

If I upsize DB2, Table2 to SQL, I can no longer link from MSAccess DB1,
Table1 to MSAccess DB2, Table2_SQL. (The new link from MSAccess DB2,
Table2_SQL to SQL does work). And, no, I do not want to modify the
front-end to go directly to the backend SQL.
 
Back
Top