Linking to a Linked Access Table

[Hmadyson]

I have an application in many locations. All people have the same front end on their computers and their front ends connect to backends on a mapped lan drive that is the same so everyone can get at the data that is only available for their location.

We have an issue where the people in one location only want to access the data in another location, so their drive is not mapped to where this data will be.

I created a backend database for them that links to the other location.

Now whenever I open the application mapped to this new location it cannot find the data. I am guessing that you cannot link to a linked table? Does anyone have any suggestions or have seen where this works?

 

[lupins46]

If your frontend is fileA, its backend is FileB and FileB includs a link to TableT in FileC.

In FileA you cannot Link to TableT in fileB because that is also linked. But, in FileA, if you Import TableT from FileB you will create a link to TableT in FileC. In other words the process of Importing imports the link rather than the table.

 

[Hmadyson]

That would require me to have 2 front-ends, one with links to tables and one with imports of links of tables, right?

 

[lupins46]

No. They can all go into the one front-end. You would end up with some links pointing to one mdb file and others to a different mdb file.

 

[Hmadyson]

Yeah, but I would have to make my front end twice as complicated to use different links in different cases.

 

[lupins46]

Life's tough ain't it!
Good luck in finding an alternative.

 

[HitechUser]

Hmadyson,

I have not tried this but I think it may work.

Create a select query (select all fields). The select query does not care that it references a linked table.

Then instead of attempting to link to the linked table just create a link to select query.

db1 > links to query on db2, db2 query selects all from db2 link that links too db3 table.
Make sense?????

Can you try this a let me know??

 

[Hmadyson]

Good thought, I tried it, but it did not work either.