You can perform security functions programattically 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.google.c om...
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