Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Setting up form permission using code
- Thread starter jjoe
- Start date
LarryDeLaruelle
Technical User
Joe:
A better (and easier) solution is to use the Access security feature. (Tools, Security)
You can create groups having the permissions you want to give, then create user accounts and assign the users to the groups based on the permissions you want them to have.
You should also create a workgroup file to control access to the db.
The details are too lengthy to go into here, but there is a FAQ in this section that links to Microsofts site on the Security Topic. If you are interested in protecting your application this is well worth reading.
Hope this helps.
Larry De Laruelle
larry1de@yahoo.com
A better (and easier) solution is to use the Access security feature. (Tools, Security)
You can create groups having the permissions you want to give, then create user accounts and assign the users to the groups based on the permissions you want them to have.
You should also create a workgroup file to control access to the db.
The details are too lengthy to go into here, but there is a FAQ in this section that links to Microsofts site on the Security Topic. If you are interested in protecting your application this is well worth reading.
Hope this helps.
Larry De Laruelle
larry1de@yahoo.com
MichaelRed
Programmer
Joe,
It is certainly possible. Since it is generally only done once per group/form, I wouldn't recommend it.
First, it would take more time to set up the code than to just set the permissions (Manually).
Second, you would be left with a "Copy" of the permissions - and a road map for the 'world' as to how to change them more-or-less at their convenience.
Thrid, you will have created an additional "Maintenance" issue, since you could change the permissions either in the security manager or in your "code" (and/or any table(s) you might create in/for the process.
Like the tic-tac ad says,
" ... yes, but I wouldn't recommend it ... "
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
It is certainly possible. Since it is generally only done once per group/form, I wouldn't recommend it.
First, it would take more time to set up the code than to just set the permissions (Manually).
Second, you would be left with a "Copy" of the permissions - and a road map for the 'world' as to how to change them more-or-less at their convenience.
Thrid, you will have created an additional "Maintenance" issue, since you could change the permissions either in the security manager or in your "code" (and/or any table(s) you might create in/for the process.
Like the tic-tac ad says,
" ... yes, but I wouldn't recommend it ... "
MichaelRed
redmsp@erols.com
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question