Split Data Base - IP Change

[navkeshchawla]

I have a data base which is lying on server - back end and front is on 17 machines. Because of some firewall restrictions, I have to put front end on user's machines for better connectivity. Now the problem is quite oftenly server IP changes and because of that I have to roll back all the tables and split the data base again because tables are linked thru server IP.

Is there any method to autoupdate server IP for connectivity? Or I am thinking if there is a way of making a field in one table in which I can put / change IP and automatically link is created/changed.

Or if somebody can help me on this ...... I have seen many databases where continous frontend development happens. They make a command line at start-up. So when users opens frontend on machines, command line triggers and check if application is same as of server. If not then that copies the fresh frontend application from server and replaces exising on local machines.

By this I will be able to use my frontend development and user will get updated too.

 

[MicroE]

The best solution is to create a function that will update the local FE database if an update is available. Running a batch script file to update the FE and launch the application is a good way to do this.

Check Out:
http://www.myaccesstips.com/deploy/deploy.html

 

[RuralGuy]

You should be using the UNC rather that an IP address. Is the IP address a requirement?

 

[navkeshchawla]

yes this is a requirement. So how can I use IP changed in linked table to front end db