Client/Server Problem

[Wayne]

Hi,

We are in the process of creating a centralized database.The main database will be in a 2003
server and the form which is used to edit the data will be in the client machine (xp pro). However, the clients are connected in different places and they will connect to the server through Internet. How can I achieve it?
Can I do the following the steps to achieve it?
1. Create a shared folder in Server
2. Setup the user permission to the folder for login
3. Put the Access file to the folder
4. Let multiusers to access and edit the access file

Is it OK?
Thank you very much!

Wayne

 

[Wayne Morgan]

For information on setting up a split database (front-end/back-end) see this link.

http://www.granite.ab.ca/access/splitapp/index.htm

However, accessing the file over the Internet requires a little more work. You need to do one of two things. 1) Set up remote control software such as terminal services, PC Anywhere, or Citrix to run the database from the host machine and just send the screen updates across the Internet. 2) Create web forms that access the database. The FrontPage and IIS groups can help you with this.

--
Wayne Morgan
MS Access MVP


Hi,

We are in the process of creating a centralized database.The main database will be in a 2003
server and the form which is used to edit the data will be in the client machine (xp pro). However, the clients are connected in different places and they will connect to the server through Internet. How can I achieve it?
Can I do the following the steps to achieve it?
1. Create a shared folder in Server
2. Setup the user permission to the folder for login
3. Put the Access file to the folder
4. Let multiusers to access and edit the access file

Is it OK?
Thank you very much!

Wayne