If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
re-linking backend on shared folder
I have several front ends on different computers connected to a single
backend on a shared folder on one of the computers. All is fine untill I update the front ends and then have to manually re-link each one with the backend. Since I am modifying the front end on my own machine and then copying it to the other machines, the path to the back end will not be the same. Is there a way I could have a small text file or excel file in the same folder as the front end that has the location of the backend and use it to somehow to relink the tables? |
#2
|
|||
|
|||
re-linking backend on shared folder
Google "Tony Toews." He has a fantastic FE updater on his website.
-- Milton Purdy ACCESS State of Arkansas "Nick Del Vecchio" wrote: I have several front ends on different computers connected to a single backend on a shared folder on one of the computers. All is fine untill I update the front ends and then have to manually re-link each one with the backend. Since I am modifying the front end on my own machine and then copying it to the other machines, the path to the back end will not be the same. Is there a way I could have a small text file or excel file in the same folder as the front end that has the location of the backend and use it to somehow to relink the tables? . |
#3
|
|||
|
|||
re-linking backend on shared folder
On Wed, 3 Mar 2010 14:10:01 -0800, golfinray
wrote: Google "Tony Toews." He has a fantastic FE updater on his website. http://www.granite.ab.ca/access -- John W. Vinson [MVP] |
#4
|
|||
|
|||
re-linking backend on shared folder
Yes that is an impressive tool. But not really what I'm looking for.
I'd like to hard code the startup form to look for a file in the current folder that has the path to the backend. The file could be an excel file or text or even another database. This way, I could set up each individual machine once with their own path to the backend. Then as I update the front end, it will always look at the file in its own folder for the location to the backend. Is that possible? On Mar 3, 5:10*pm, golfinray wrote: Google "Tony Toews." He has a fantastic FE updater on his website. -- Milton Purdy ACCESS State of Arkansas |
#5
|
|||
|
|||
re-linking backend on shared folder
Nick Del Vecchio wrote:
Yes that is an impressive tool. But not really what I'm looking for. I'd like to hard code the startup form to look for a file in the current folder that has the path to the backend. The file could be an excel file or text or even another database. This way, I could set up each individual machine once with their own path to the backend. Then as I update the front end, it will always look at the file in its own folder for the location to the backend. Is that possible? I don't get it... Is each user connecting to a different backend? You can use the UNC path to the backend file to connect. Why not store it in a custom property in the database? Then the user cannot modify it unless he knows how... I suppose you could try reading from a text file by using LineInput and friends... can't find any documentation on them anymore... I guess the Access folks decided that nobody needs it anymore... -- Message posted via http://www.accessmonster.com |
#6
|
|||
|
|||
re-linking backend on shared folder
I don't get it... Is each user connecting to a different backend? *You can use the UNC path to the backend file to connect. *Why not store it in a custom property in the database? *Then the user cannot modify it unless he knows how... I don't know how to store the path in the custom property in the database. Any examples of how to do that would be appreciated. |
#7
|
|||
|
|||
re-linking backend on shared folder
Well, after looking into this further, I think I'd like to stick with
my original idea and have an ini file in the same folder as the front end which contains the backend UNC path. This way if I copy in a new FE, my startup code reads the .ini file, connects the BE file and users never have to worry about the linked table manager. I've seen a lot of people talking about doing it this way, buy I haven't seen any code that shows my how to do it. Would someone care to share this information? Thanks |
Thread Tools | |
Display Modes | |
|
|