unless you need to link the tables dynamically at runtime, it's easy enough
to do this manually - once, before distributing the FE to your users -
without using any code, etc. suggest you open the FE and delete all linked
tables, then compact the db. then from the menu bar choose File | Get
External Data | Link Tables. when the link dialog comes up, navigate to the
BE.mdb through Network Neighborhood (or My Network Places, or whatever it's
called on your PC) rather than through the mapped drive letter route. follow
through the rest of the dialog to choose the tables to link, etc, and you're
done.
and if you haven't already, distribute the FE database to each user - don't
allow all your users to open the same, single FE database regardless of
where it's housed.
hth
"Matt" <md*******@yahoo.comwrote in message
news:11*********************@l70g2000hse.googlegro ups.com...
Hi All,
I have found a version of my answer on GG, but I have not been able to
find my exact answer, thus the post.
I am using Access 2000
Situation:
I have a multi user frontend database located at 'O:\FE.MDB'. This
database contains tables linked to the backend 'M:\BE.MDB' (names have
been changed to protect the innocent). These tables were linked via
the Linked Table Manager and were created using an absolute path
(using the drive letter).
I want to be able to link to the tables using the server name rather
than the drive letter.
What I have = "M:\BE.MDB"
What I want = "\\Server\root\BE.MDB"
Keep in mind that the frontend resides on an entirely different server
that the backend (all of the solutions I have come across require the
frontend and backend to be in the same folder).
Is this even possible?