path to server question

[Guest]

Hi guys. I need your help (obviously)

I have a .mde front end that I created on some of my groups pc's with a
backend on our network drive. However, not everyone maps to the drive with
the same letter and therefore I cannot get my app to work. Any suggestions
on how I can setup the app to look for the share\server name without the
letter map?

 

[Guest]

Welcome to the wonderful world of UNC. Typically when you map a drive your
are abbreviating a path such as \\servername\c$ to g:. You need to you an
explicit format know as UNC (\servername\c$). Also, from an IT stand point
you really should have a standard drive mapping initialization file/routine
to avoid such issues... but that is another issue altogether.

 

[Guest]

Thanks Daniel, but now, can you explain how I setup my .mdb / .mde to point
to the UNC of the server? Thanks!

 

[Joan Wild]

When you link the tables, use My network places to locate the backend - that'll use the UNC pathname.

 

[Allen Browne]

If you link the tables through the Network Neighborhood rather than a mapped
drive letter, then that will be the path of the linked tables.

You can include code to reassign the linked tables if you wish. There's a
relinking module in the solutions.mdb sample database at:
http://support.microsoft.com/kb/248674