BASIC security

  • Thread starter Thread starter Steve Z via AccessMonster.com
  • Start date Start date
S

Steve Z via AccessMonster.com

I have a fair amount of experience with Access but have never had to use
security until now. First of all I was playing with it and found that it
added security (users) to every access file on my machine. All I want to
really do is have 2 users - 1- Admin and 2-all others. The "all others" is
just so I can stop anyone from getting into and modifying any table, query,
form report, etc settings or change the design in any way...real general. I
am creating this database to deploy at a company that wil have about 10 users.
 
Thanks Douglas! There is alot of info there.

One thing it doesn't point out is why security is transfered to every access
database I have on my laptop. I assume a security file reside on my computer?
 
I suspect that when you experimented, you ended up changing the default
workgroup file (system.mdw), or else you made your new workgroup file the
default.
 
Steve said:
Thanks Douglas! There is alot of info there.

One thing it doesn't point out is why security is transfered to every
access database I have on my laptop. I assume a security file reside
on my computer?
Click to expand...

It's because Access security prompting is not about the file you are opening.
It is about the session you are starting. At least as it pertains to prompting
for a login. Your other files do not care about you logging in or not, but you
are starting a sesssion using a workgroup file that has a password on the
default user "Admin" and THAT is what causes the prompt.

When you read the recommended documents enough times this will all be clear.
 
In addition to the official MS documentation, you may find some of
these helpful.

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Security


I have a fair amount of experience with Access but have never had to use
security until now. First of all I was playing with it and found that it
added security (users) to every access file on my machine. All I want to
really do is have 2 users - 1- Admin and 2-all others. The "all others" is
just so I can stop anyone from getting into and modifying any table, query,
form report, etc settings or change the design in any way...real general. I
am creating this database to deploy at a company that wil have about 10 users.
Click to expand...

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Back
Top