Change form design after split

M

Matt W.

This might be a stupid question but i am about to split a database and put
the b.e. on the share drive and the f.e. on the users machines. after i do
this, how will i make a change to the design of a form if i need to so it is
applied to all the users' forms??
 
R

Rick Brandt

Matt said:
This might be a stupid question but i am about to split a database
and put the b.e. on the share drive and the f.e. on the users
machines. after i do this, how will i make a change to the design of
a form if i need to so it is applied to all the users' forms??
Click to expand...

You make changes to YOUR copy of the front end and test. When satisfied with
the changes you give a new copy of the front end to all of your users. Most of
the time you set up some sort of automatic or semi-automatic method for
replacing the user's file with the latest copy.

Tony Toews created a free utility for exactly this purpose, but you can create
your own system as well.
 
M

Matt W.

would it be a bad idea to allow both the front end and back end to reside on
the shared drive and just create a shortcut from the users machine to the
front end? If i were to do this i could just make the change to the front end
 
D

Douglas J Steele

You lose a lot of the benefit of splitting doing that.

Each user should have his/her own copy of the front end. Users sharing the
same front end significantly increases the risk of database corruption. Each
user's copy should ideally be on his/her hard drive. This minimizes the
amount of network traffic.
 
Top