How to convert a standalone Access database to a Client Server DB

[Guest]

Hi , I have created a standalone database Application using Access 2000 in
which I import a Text File and convert it in to a table. I also had an Input
form through which I Add data into the same Table.. Now the problem is that i
want to place this Form at the Server, so that the Users who are sitting at
the remote locations (They can Access our Corporate Network via Lan/WAN) can
use this form and Can Input the Data in Same Table.
Need your Help for this ,,Kinldy Guide

 

[Rick Brandt]

Hi , I have created a standalone database Application using Access
2000 in which I import a Text File and convert it in to a table. I
also had an Input form through which I Add data into the same Table..
Now the problem is that i want to place this Form at the Server, so
that the Users who are sitting at the remote locations (They can
Access our Corporate Network via Lan/WAN) can use this form and Can
Input the Data in Same Table.
Need your Help for this ,,Kinldy Guide

Access cannot be run in the normal fashion over a WAN reliably. The usual
recommendation is to provide a web interface to the database or use remote
access software like terminal services. This allows all of the file i/o to stay
on the LAN where the file resides and the only thing going over the slower and
much less reliable WAN connection are screen updates and keyboard/mouse inputs.