link table using UNC

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
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,
Click to expand...

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
 
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.
Click to expand...

Picking nits, but that would be

\\MyServer\MyDatabase\MyMDB\SomeDatabase.mdb

....or:

C:\MyDatabase\MyMDB\SomeDatabase.mdb
 
Back
Top