link table using UNC

[iccsi]

I would like to link backend table using UNC like

\\MyServer\MyDatabase\MyMDB

Currently, I use network drive mapping.

If I can use UNC then how can I do it?


Your help is great appreciated,

 

[John W. Vinson]

I would like to link backend table using UNC like

\\MyServer\MyDatabase\MyMDB

Currently, I use network drive mapping.

If I can use UNC then how can I do it?


Your help is great appreciated,

The simplest way if you're using File... Get External Data... Link or the
Linked Table Manager is to navigate to the backend via Network Neighborhood,
rather than My Computer (use your own OS's equivalents for these).

If you're linking in code, it's just as easy to use
"\\MyServer\MyDatabase\MyMDB" in the connect string as it is to use
"C:/MyDatabase/MyMDB", and it will work correctly.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[David-W-Fenton]

If you're linking in code, it's just as easy to use
"\\MyServer\MyDatabase\MyMDB" in the connect string as it is to
use "C:/MyDatabase/MyMDB", and it will work correctly.

Picking nits, but that would be

\\MyServer\MyDatabase\MyMDB\SomeDatabase.mdb

....or:

C:\MyDatabase\MyMDB\SomeDatabase.mdb