 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / December 2004Coding IP address for Linked tables
This will most likely have a simple resolution but I am beating my head against the wall trying to figure it out.... I have a FE/BE application designed and built (access 2000). Everything works fine but now it is time to migrate the BE to a server for multiple users. The FE will be replicated and distributed to different machines so I know the basics. Is there a way to write into code the IP address for the BE application so no matter what the share name is to different people the FE will always find the BE? I probably am not making much sense as I have not described the LAN setup.... Everyone has a share name that they use for different servers. Not every person has the same share scripted into their user profile so the DNS is different.... Hope someone can make heads or tails of my woes.... Any help would be apprecaited..... MartyK >I have a FE/BE application designed and built (access 2000). Everything >works fine but now it is time to migrate the BE to a server for multiple [quoted text clipped - 7 lines] >every person has the same share scripted into their user profile so the DNS >is different.... 1) The server and share name should be the same for all the users. Ie \\ServerName\ShareName. You can relink your tables to that share name by running the Link Tables Wizard and navigating through the network neighbourhood. 2) If there are indeed different server names, possibly due to different LANs and such, then you can programmatically relink the tables as required. Relink Access tables from code http://www.mvps.org/access/tables/tbl0009.htm I store the settings in an INI file on the client system so that when the client gets a new FE the code looks in that INI file and relink the table to the new share. Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.