UNC

[gwog]

Using Access 97.

A database was created, with a front end and a backend.
Both residing in the same location on the server. The location is mapped to J drive at location.

Users at my location have no problem accessing the database to view the reports.

However, user at another location have the server mapped to the M drive, and seem to be having problems accessing the database.

How do I use UNC to adapt the existing database so that it does not matter if the server is mapped to J or M?

Thank-you so much for you help. Don't worry about offending me by using very simple, basic, directions - the easier to understand the better.

Lisa.

 

[jrbarnett]

Hello again lisa.

UNC will only sort the problem if the servers have the same name at each location (it isn't 100% clear if this is the same or not). What you have to do is instead of hard coding paths into the code, use something like:

\\Servername\Sharename\Filename.mdb.

Of course, this solution isn't feasible if the servers have different names or shares, but you could use drive mappings but use relative rather than absolute paths (eg use Folder\filename.mdb rather than J:\Folder\Filename.mdb)

One thing though: using UNC is slightly slower than using a mapped drive, so don't be surprised if some users moan that the DB has slowed down.

John

 

[gwog]

John,

The server have the same name:

\\hfkser01\sys\shared
But I don't understand how to "code" the path.

Where do I put the code?

Do I build a module that simply says:

docmd.opentable(\\hfkser01\sys\shared\databasename.mdb

But then how do I link a specific table from that database.

How do I make it link it when the database is opened?

Sorry, I'm full of questions.

Thanks for your continued help.

Lisa.

 

[psemianonymous]

1. The simplest way to update your table links is to delete the ones that are there and re-add them. When you are browsing for the database file, be SURE to use the UNC instead of the network drive. In fact, you can directly type the whole thing into the file dialog box if you want, to be absolutely sure. Then re-add all the tables you need, and you should be good.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[gwog]

foolio12,

Thanks! Now I understand. I just clicked link table and typed the entire path in and it worked.

Well, my users at the other location hasn't tested it yet - but at least I can see that the linked table is mapping to the server name not a drive letter.

So I think it is going to work.

Thanks to everyone who helped.

lisa