Linked Table Manager (UNC Paths?!)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Daniel P said:
Hello,

I have a database which is comprised of a front end and a back end and
Click to expand...
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
Click to expand...
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
 
Arvin Meyer said:
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.
Click to expand...

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.
 
Back
Top