BASIC security

[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.

 

[Douglas J. Steele]

Your best bet is to read the Access Security FAQ at
http://support.microsoft.com/support/access/content/secfaq.asp

Read it thoroughly several times, work on a copy of your database, and make
sure you don't leave out any steps.

 

[Steve Z via AccessMonster.com]

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?

 

[Douglas J. Steele]

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.

 

[Rick Brandt]

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?

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.

 

[Steve Z via AccessMonster.com]

Thanks Rick...makes sense.

 

[jacksonmacd]

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.

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

 

[Steve Z via AccessMonster.com]

Great, thanks.