share db with users in different States

Joe8915

Registered User.
Local time
Today, 14:53
Joined
Sep 9, 2002
Messages
820
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
 
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).
 
However, the BEST option for Access is to use Terminal Services or Citrix. Connecting Access to a WAN is going to be SLOOOOOOWWWWWWWW.
 
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
 
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.
 

Users who are viewing this thread

Back
Top Bottom