link table

[olga p.]

Hi,

I have a problem with a link table. I have two Access DB's on the Server
(different maps). DB1 has a linked table from the DB2. I need a query for
ASP-page that uses two tables (tbl_A and tbl_B) of DB1, tbl_B is the linked
one. When I run my ASP-page it does'n work because the linked table can't be
found. It is right. When I open linked table manager I see:

(T:\my_map\MyDB.mdb)

Absolute link and I need a relative one! Something like

(...\my_map\MyDB.mbd)

But I can't type it!. When I try to link the table again, I get the same
hard link. On my computer I've got all Server-maps onder the letter T, but
it's only on my computer. All maps I need are on D:\ftproot (Server point of
view). So, If I could type something like:


(D:\ftproot\my_map\MyDB.mdb)

it would do, but I can't!

I hoop you understand my problem. Anyone, how can I solve it?

thank you,

Olga Persha

 

[Gary Miller]

Olga,

I would suggest using the browsing feature in the
LinkedTableManager to browse across the network through
Network Neighborhood for your two databases. If the second
table that you need is a linked one in one of the databases,
I would not try to do a second link on that one, but rather
link it individually to your new database. You will now have
links from two databases. No problem there. Using Network
Neighborhood to setup the links should give you the relative
path that you want.

Gary Miller