Linked Table Manager (UNC Paths?!)

[Guest]

Hello

I have a database which is comprised of a front end and a back end and obviously the front end is linked to the back end. My question being is there a way to get the "links" to be expressed in a UNC path format instead of my local computer's drive mappings naming

Currently it maps the linked tables "h:\......" and would like it to be expressed as "\\server01\eng\.....

Thank you for your insight

Daniel

 

[Arvin Meyer]

Hello,

I have a database which is comprised of a front end and a back end and

obviously the front end is linked to the back end. My question being is
there a way to get the "links" to be expressed in a UNC path format instead
of my local computer's drive mappings naming?

Currently it maps the linked tables "h:\......" and would like it to be

expressed as "\\server01\eng\....."

Use the Link table manager to select the tables and type the UNC path in the
filename box. You can also link in code using the RefreshLinks method, and
use the UBC path.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J. Steele]

obviously the front end is linked to the back end. My question being is
there a way to get the "links" to be expressed in a UNC path format instead
of my local computer's drive mappings naming?
expressed as "\\server01\eng\....."

Use the Link table manager to select the tables and type the UNC path in the
filename box. You can also link in code using the RefreshLinks method, and
use the UBC path.

Actually, you don't have to type them: you can select them through the File
Open dialog. The "trick" is that you need to navigate to the back-end
database through the Network Neighborhood, rather than by selecting the
mapped drive.