Question about servers

A

Afrosheen

Access 97 is installed on one main computer and acts as a server. There are
two other computers that have access to the program probably through a
network I don't know. When ever they have to change a form on the main
computer, the person has to physically go to the other two computers and
change the same form there also. Does this sound correct?

I'm just looking at the program possibilities and see if I want to tackle
upgrading them to either Access 2003 or 2007.

I really don't know what's going on and any help or direction would be much
appreciated. Can you run a program through a small net work?

Thanks
 
A

Arvin Meyer [MVP]

Afrosheen said:
Access 97 is installed on one main computer and acts as a server. There
are
two other computers that have access to the program probably through a
network I don't know. When ever they have to change a form on the main
computer, the person has to physically go to the other two computers and
change the same form there also. Does this sound correct?
Click to expand...

Yes, a separate front-end for each workstation. An easier way to handle the
updates is to save a copy of the changes on the server and simply download
and replace their local copy with the one from the server.
I'm just looking at the program possibilities and see if I want to tackle
upgrading them to either Access 2003 or 2007.

I really don't know what's going on and any help or direction would be
much
appreciated. Can you run a program through a small net work?
Click to expand...

I suggest you get some more background before attempting to upgrade
anything. Have a look at:

http://www.accessmvp.com/Strive4Peace/Index.htm

and

http://www.access-freak.com/tutorials.html
 
Top