Linking to linked tables

[MartinF]

Hi,

Is it possible in access 97 to link to a table in another database which is already linked to another table in a third database.

If so how do i set up the link, as it does not allow you to do it from the 'Get external data' menu.

Many thanks

 

[MichaelRed]

Martin,

As far as I know this is NOT possible.

Also, WHY would you want to do this? Just link to the (real) source db.

MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[MartinF]

The reason for doing this was as follows:

I have a front end database that links to several backend databases which are picked off a menu. However the backend databases are relative to one of two years and work off one of two sets of dates which are held in another database, so it was just for a short cut to get the front end to look at the right set of dates by having the backend already linked into to the correct date table.

However, i have now got round the problem by making the front end database creat its own internal date table to fit the backend that it connects to.

Thanks anyway for your feedback

 

[JerryDennison]

While you cannot link to a table that is itself linked, you can import this table. Doing so will treat it as a link, i.e. it the table were linked in the db you're importing it from it will also be linked in the db you import it to.