basic security question

[Barb]

Hi, I never set up security yet.
I have a database where I have info from 3 offices.
When someone logs on I want to ask him "Office Name" and
then give him access only to his office info. Let sey I
have 100 clients between 3 offices. When someone from
Chicago logs on I want him to only see Chicago
clients. "Office" is one of the fields in my main table.

Can someone please walk me through it?

Thanks
Barb

 

[Joan Wild]

You could setup a form with a combobox that they choose their office, and
then have a criteria on all your queries that references this value.

However, I don't see that this is 'secure' by any stretch of the
imagination. What's to stop someone in Chicago, from picking or entering
Boston and seeing the Boston clients?

If you want to prevent that, you'd need to setup security and then restrict
queries based on their username.

You'll need to download and study the security FAQ. It isn't trivial so be
sure you understand it before implementing (practice on a copy of your mdb)
http://support.microsoft.com/?kbid=207793