link table to a link table

S

Souris

I would like have a link table to a link table. I am not sure that does
Access support this?

Should link table to a physical tables or could be a link table link a link
table?

For example, I have 2 different apps and use different databases.

I have app 1 has FE1 and BE1 and app2 has FE2 and BE2.
Is it possible that FE2 link a table in BE2 that BE2 is a link table to link
BE1?

Your informaiton is great appreciated,
 
R

Ron2006

As far as I know you cannot link to a linked table.

But the question really is why would you want to.

Simply have FE2 link to the real tables where they reside so in this
case you would set it up to have FE2 link to tables in BE2 AND
BE1.

A front end can link to as many tables and as many BE type tables as
is needed (within reason).

For instance I have a FE1 that links to tables in a BE1 and to
BE3 and to BE1Temp Tables.

There is no constraint that all linked tables be in the same BE.

Ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top