Server Question Regarding Forms

F

FerryMary

I've been studying but want to confirm this peice of information.

Since the front-end will be manually installed at the three locations (mine
and 2 others) and the back-end will be on the server, my front-ends can use
forms instead of pages,,,,,,,right?

Pages would be more for a web type setting instead of a server setting if
I'm reading these descriptions correctly.

As always,,,thanks everybody.
 
W

Wayne Morgan

Correct. However, where are these computers (reference the server location)
that will have the front end? If they're not on the local, hard wired
network, you will probably run into problems.
 
F

FerryMary

They are not local. It would be an FTP Server at three separate locations.
They do have continuous server connection. <<Except during hurricane
season>> No two shops should be entering information relative to the same
equipment if that matters.

Thanks for any help or suggestions.
Mary
 
W

Wayne Morgan

The problem with the connection not being local is that if the connection
should get interrupted momentarily while writing to the back-end file, you
will most likely corrupt the file. Also, unless you have very good upload
and download speed on the connection, I don't think you'll like the
performance.

This is the time to have a web server using ASP pages connect to the
database and have the users use the web forms to make their entries. This
way the connection to the database file is on the same computer as the one
making the entries (the web server) or another local computer. Another
option would be to set up the server database as a master and have replicas
at the sites that you synchronize. I think you'll find the web setup easier.
 
F

FerryMary

From what I understand, via my IT guy, the program would be loaded to a drive
on the server and the program(front-end) would be mapped to the 3 users.
With this being the case should I change my forms to pages, or since they are
using the program from the server will this take care of synchronizing the
sites?

Thanks so much
Mary
 
W

Wayne Morgan

It sounds as if you're using Terminal Services, Citrix, or some other remote
software. If this is correct, you should be fine. Each user should have
their "own" copy of the front-end with a common back-end file to hold the
data.
 
Top