linked table reference

[hi there]

hi folks,

i've recently placed a split dbase on a server with the back end on a shared drive and the front end on individual workstations. i've read setting up a multi-user environment this way makes the dbase run faster (jet runs on each workstation) and reduces the network traffic. here's the problem. the network administrator just told me that i need to move the back end to another directory on the server. my question is how do i access the linked tables (front end) reference path to the back end. do i have to delete all of the tables on the front end applications, move the back end, and then re-link the tables or is there an easier way to do this? in general, how do you access the reference path of a linked table if you need to modify it? thanks to everyone for any help with this.

 

[John.Woody]

In Access 2K Go to the menu Tools, Database Utilities, Linked Table Manager.

In Access 97 its Tools Addins Linked Table Manager.

You can then refresh your links to the path of your choice.

HTH
John

 

[hi there]

hi john,

thanks for the reply. this worked out great for choosing a different reference path using the windows dialog box, but i was wondering if there was a way for me to type the reference path. the IT group has done something a little funny. when they mapped the drives on the individual workstations they didn't use a uniform naming convention. for example the drive in question on one workstation is called F:/ and on another is called Y:/ but they still refer to the same drive. so basically what i have to do is define the reference path to the server computer(\\chsvr01\exampledirectory\access.mdb). therefore the connection will work regardless of what they name their drive. i guess i can do this with the windows dialog box using network neighborhood, but do you have any other ideas for a better way to do this?

many thanks again for your help.

 

[Autoeng]

You should search for "linking" as there have been many posts related to the type of linking that you need to do.

 

[John.Woody]

When you select the links to be updated you can go through network neighbourhood using the full UNC path as you wish to.

 

[hi there]

thanks autoeng and john for your replies. they were very helpful.

 

[hi there]

[URL http://www.accessprogrammers.co.uk/forums/showthread.php?s=&threadid=45545&highlight=linking[/URL]

not sure if this link will work but i found a great thread on my question with responses from autoeng and pat.

 

[Autoeng]

Need to correct your post by adding another bracket ] to the end of the first URL.

 

[hi there]

thanks again autoeng.

[url]http://www.accessprogrammers.co.uk/...ghlight=linking[/URL]

not sure if this link will work but i found a great thread on my question with responses from autoeng and pat.

 

[hi there]

aargh! my link still doesn't work. anyway for folks interested in this thread the title of the thread is

"more info on database splitting"

 

[Autoeng]

I fix it.

http://www.access-programmers.co.uk...545&highlight=more+info+on+database+splitting

 

[Vassago]

You can actually type the full path at the bottom where you type the name of the database.

Just type the full network path as shown above the way you typed it in the file name section and that should work for you.

Let me know if that helps.

Vassago

 

[hi there]

thanks for all the help autoeng, john, and vassago.