Setting up permissions....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone please help with this problem? I want to know what is the best
way or code to assign permission to different users in the database.
Basically I want to enable or disenable buttons base one what user type it
is. Also if I add another user type to the DB I want to be able to give that
user type permission without going back into the code.

Can anyone please help me out with this??

Thank you,
 
dcash45 said:
Can someone please help with this problem? I want to know what is the
best way or code to assign permission to different users in the
database. Basically I want to enable or disenable buttons base one
what user type it is. Also if I add another user type to the DB I
want to be able to give that user type permission without going back
into the code.

Can anyone please help me out with this??

Thank you,
Click to expand...

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.
 
You'll want to use User-Level Secuity to set up user accounts and
permissions. Read the Secuity FAQ carefully:

http://support.microsoft.com/support/access/content/secfaq.asp?

Once you've implemented the user and group accounts, you may want to use my
LockIt code to lock individual controls:

http://www.datastrat.com/Code/LockIt.txt

If there's just a few users, and all you want to control is one or 2 forms,
you can get the login username from:

http://www.mvps.org/access/api/api0008.htm

and use that with the LockIt function.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top