nerdcore
MIS
- Jan 23, 2003
- 26
I'm creating a "secure" database using the .mdw file and user/group permissions. I have a switchboard form with about 8 buttons that open up the various data entry forms in the database. What I need to do is upon loading the switchboard form, test the permissions that the CurrentUser has to each data entry form and disable any buttons for which the user has no access. The problem I am running into is that I can't find any comprehensive list of the different security constants available. I have been able to glean a few from various code samples on the net, but not even in the VBA help can I find this list. These constants will be compared against the AllPermissions property but my help file has no information on this property. I even tried reinstalling the help files for access but no luck. Does anyone know where I can get a list of these security constants? A few of them (for reference) are:
dbSecFullAccess
dbSecReadDef
The ones I am really interested in are those which can test whether I have "open/execute" permission on a form, and "Update" permission on a table, but eventually I will need all that are available. Thanks in advance!
dbSecFullAccess
dbSecReadDef
The ones I am really interested in are those which can test whether I have "open/execute" permission on a form, and "Update" permission on a table, but eventually I will need all that are available. Thanks in advance!