Adding users to secured database

[Therese A. Sorna]

Hello all,

Is there a way to add users to a secured database without having to go
into Security -> User and Group Accounts? I have a table for all
employees on a secure database, and want to be able to just add new
employees once (ie into the emplyee table not the security section),
and having it added to the user accounts.

Thanks in advance,
Therese

[Larry Linson]

You can perform security functions programatticall y from an user account
with the required permissions. There's good coverage in the Access <version>
Developer's Handbook by Litwin, Getz, et al, published by Sybex. There's
coverage in online documentation and the Microsoft web site, but it is
scattered and you have to search it out.

However, I'd caution that by keeping security information in just another
database table, you are likely compromising the security of your database.
Access security, while not unbreakable, is more difficult to break than it
is for someone to get into an Access table.

Larry Linson
Microsoft Access MVP
"Therese A. Sorna" <ta*****@yahoo. com> wrote in message
news:be******** *************** ***@posting.goo gle.com...

Hello all,

Is there a way to add users to a secured database without having to go
into Security -> User and Group Accounts? I have a table for all
employees on a secure database, and want to be able to just add new
employees once (ie into the emplyee table not the security section),
and having it added to the user accounts.

Thanks in advance,
Therese

[Therese A. Sorna]

Any hints on what I should search for on the microsoft website. I
have searched extensively, but have found nothing that shows me how to
do this. Or, perhaps you can share the code?

Thanks,
T

"Larry Linson" <bo*****@localh ost.net> wrote in message news:<Jg******* ********@nwrddc 02.gnilink.net> ...

You can perform security functions programatticall y from an user account
with the required permissions. There's good coverage in the Access <version>
Developer's Handbook by Litwin, Getz, et al, published by Sybex. There's
coverage in online documentation and the Microsoft web site, but it is
scattered and you have to search it out.

However, I'd caution that by keeping security information in just another
database table, you are likely compromising the security of your database.
Access security, while not unbreakable, is more difficult to break than it
is for someone to get into an Access table.

Larry Linson
Microsoft Access MVP
"Therese A. Sorna" <ta*****@yahoo. com> wrote in message
news:be******** *************** ***@posting.goo gle.com...

Hello all,

Is there a way to add users to a secured database without having to go
into Security -> User and Group Accounts? I have a table for all
employees on a secure database, and want to be able to just add new
employees once (ie into the emplyee table not the security section),
and having it added to the user accounts.

Thanks in advance,
Therese

[Larry Linson]

"Therese A. Sorna" wrote

Any hints on what I should search for
on the microsoft website. I have searched
extensively, but have found nothing that
shows me how to do this.
The only security item that I know about, for sure, is the Security FAQ
which can be downloaded from http://www.microsoft.com/downloads/. Two
places to _start_ searching would be the Knowledge Base at
http://support.microsoft.com, using Advanced Search, and the Microsoft
Developer Network site, http://msdn.microsoft.com.
Or, perhaps you can share the code?

The only security code that I have written was minimal, was done a long time
ago, and was in a client's proprietary database. Of course, I can't share
the code from the Developer's Handbook, because it is copyrighted - sorry.

Larry Linson
Microsoft Access MVP