share db with users in different States

[Joe8915]

Have no clue on the best way to do this. I have a db and I have 3 users that need to update the db. These users live in CA,TX and WY What is the best way to do this.

How to a Website?
How to a Server?

Gee, it sounds so simple even when I type it in.

Thanks

 

[apr pillai]

If the LAN/WAN is accessible in all the three states then the common Server location (with the database) can be mapped as a local drive to their respective machines as follows:

1. Right-click on the My Network icon on the desktop.
2. Select Map Network Drive.
3. Select a Drive letter in the Drive control say K
4. Enter \\ServerName\ShareFolder in the Folder control
5. Put a check mark in the Reconnect at Logon checkbox (to reconnect the server location to the machine automatically when the user turn on the computer).

 

[boblarson]

However, the BEST option for Access is to use Terminal Services or Citrix. Connecting Access to a WAN is going to be SLOOOOOOWWWWWWWW.

 

[Joe8915]

aprpillai, thanks for chiming in, checking all of my options here.

Bob, my man glad you chime in on this. I can't tell you how many times you got me out of jams.

So it sounds like I can't just upload the db on a site and use it from there. Just throwing this out, I did find site where you place the db and be able to add information.

Bob, I have no clue about Terminal Services or Citrix. All I need to do is put a the db on a site and have clerks enter information, so I can retrieve the information (payrolls and timesheets)

Bob, in the mean time I will goggle Terminal Services and Citrix.

Bob point me in the right direction

 

[Joe8915]

FYI, I just found out that using Frontpage I can import the db into a Webpage, which then I can use the free host. So far no problems.