Add new fields to split database. Backend on server

[nells]

I have a db running over LAN. The db is split with backend of server and Forms, reports etc. runing on desktops. I need to add serveral fields to backend. How do make to update the forms to 'see'the new fields ?

 

[jimmythegeek]

You have to modify the front end, then replace the copies on the user's machines. A form will not automatically see new fields unless you modify it (design), and add the new fields to whatever form you are changing.

How many users are you talking about? 10, 100, 500? The number of workstations you need to update, makes a difference on how you get the file out to them.

If you don't have that many, then just put the file on the server, and individually copy it down to the workstations, replacing the existing file.

If you have alot of users, then you may want to come up with an automated way to replace the file. You could put a batch file on the users machine that automatically goes and gets the file and replaces it, or a VB app, or have your IT dept. push it out. Several options there. Jim Lunde
compugeeks@hotmail.com
Custom Application Development