Database with users in different locations

[Amorfosis]

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

 

[Joan Wild]

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.

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?

Depends on your answer to the questions above.

 

[Joan Wild]

there is a very good chance that it will be over a WAN

You do not want to use your database directly over a WAN. More information,
including other options at
http://www.attcanada.net/~kallal.msn/Wan/Wans.html

You'll want to look into Terminal Services.

 

[Rick Brandt]

how would Terminal Services differ from the WAN, i'm not very familiar

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.