Linked table on network-change path?

[kbrooks]

Be warned....I think I went about this kind of goofy, but it works.

I had a database with only 4 users (I guess 5, with me) where they submit charge changes to me, and also enter chart tracking information in a separate table. A pretty simple deal. Recently they wanted me to give the charge changes capability to a few more users, but didn't want them accessing the chart tracking part.

I did not have the original database split into a FE/BE...the few times I've tried that I really screwed things up, and I've never investigated to see exactly where I went wrong. So basically I set up a brand new database, copied in all the forms, etc that are related to the charge entry part. Then I linked it so they point to the charge table on the original database.

My problem lies in the network part of it. On my PC, I have mapped a network drive "L" so that it points to our network's "users" folders. The whole path for the users folder is hercules\users but my machine just shows the L. Well not everyone has the letter L denoting that path...it may be E on one machine, W on another....basically whatever letter they chose.

So I would like to change the path from
L:\Coding\ChartTracking.mdb
to
\hercules\users\Coding\ChartTracking.mdb

I'm going to the linked table manager but can only refresh it, not change it. Since there are only a handfull of users, it wouldn't be a HUGE issue to go around and change their network drive to L, but it seems kind of silly to do it that way.

I know I talked in circles, sorry!!!

 

[kbrooks]

Never mind, I figured it out. We need a blushing emoticon because I'm a bumbling idiot.

When I linked the table, I found the database by clicking on my drive L, and then the correct folders.

I did it again, this time going all the way through My Network Places, Hercules, etc etc.

 

[boblarson]

Also, just for future reference, make sure that if you are going to put any kind of network path into code, etc. that you use UNC instead of drive letters.

So you would use \\myservername\myshare\filelocation
instead of L:\filelocation