Database with users in different locations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm currently building a database and it is designed to have multiple users in various locations accross the U.S. use it, and each user having certain restrictions. I've used http://www.jmwild.com/security97.htm to set up the different restrictions for my users and user accounts. Is there a need for me to adapt my security settings for this multi-user and multi-location issue? If so, then how do I do it?
I would really appreciate it if anyone could "spoon-feed" me this information, since I'm not very Access savy.
Much obliged,
Amorfosis
 
Amorfosis said:
I'm currently building a database and it is designed to have multiple
users in various locations accross the U.S. use it, and each user
having certain restrictions.
Click to expand...

How are these users at remote locations connecting? You aren't just going
to do this over a WAN connection, are you? Are you using Terminal Services,
replication,..?
I've used
http://www.jmwild.com/security97.htm to set up the different
restrictions for my users and user accounts. Is there a need for me
to adapt my security settings for this multi-user and multi-location
issue?
Click to expand...

Depends on your answer to the questions above.
 
Amorfosis said:
how would Terminal Services differ from the WAN, i'm not very familiar
Click to expand...
with that

With TS you would only be sending keystroke, mouse, and screen updates back
and forth over the wire. The actual application is running on the remote
PC and is not affected by the inherent problems with a WAN connection.

Running directly over WAN you are sending data and file updates back and
forth and will almost certainly corrupt your file. In addition the
performance would be abysmal.
 
Back
Top