In Access 2000 I am unable to set the security permissions for a Form so that I have administer permissions. It errors: You do not have sufficient permissions to make the security change. When I try to take ownership, it tells me that I must have administer permissions in order to change the permissions on the form. Catch 22. This database does not require a login to access. It logs in with the default Admin logon. Any help would be greatly appreciated.
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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Permissions 1
- Thread starter JamesonJ
- Start date
-
1
- #2
mmtraining
IS-IT--Management
This solution works with Access 97 and lower, can't test 2000 at the mo.
see if you can find a file called WRKGADM.EXE. This is a workgroup administration tool. Start it and a window opens which tells you which file contains the details of your workgroup. At the bottom of the window are three buttons. (I use the German version, so am guessing at the translation):
Button 1 - You can create a new file
Button 2 - You can attach a file with the information
Button 3 - You have finished and want to end the programm
What you have to do:
- Create a new information file under a new name, which you can think up for yourself, by using the first button. (Don't forget to do a screen shot of where the old one is and what it is called beforehand, just in case.)
- After that, attach the new file to this window by using the second button.
- Then shut the window
This seems to kill all Access-passwords that are hanging around. I have never seen the sense of giving users this means of getting round passwords. If anyone can explain this to me, I would be very happy.
When I password protect an Access application, I set up a table, which has the login names of the users as well as the rights I am willing to give them, then use a bit of VBA which reads which person is logged on and what that person can see and change. I haven't yet found out how to give illegal users an electric shock, am still working on that one.
All the best,
Carol
Berlin, Germany
see if you can find a file called WRKGADM.EXE. This is a workgroup administration tool. Start it and a window opens which tells you which file contains the details of your workgroup. At the bottom of the window are three buttons. (I use the German version, so am guessing at the translation):
Button 1 - You can create a new file
Button 2 - You can attach a file with the information
Button 3 - You have finished and want to end the programm
What you have to do:
- Create a new information file under a new name, which you can think up for yourself, by using the first button. (Don't forget to do a screen shot of where the old one is and what it is called beforehand, just in case.)
- After that, attach the new file to this window by using the second button.
- Then shut the window
This seems to kill all Access-passwords that are hanging around. I have never seen the sense of giving users this means of getting round passwords. If anyone can explain this to me, I would be very happy.
When I password protect an Access application, I set up a table, which has the login names of the users as well as the rights I am willing to give them, then use a bit of VBA which reads which person is logged on and what that person can see and change. I haven't yet found out how to give illegal users an electric shock, am still working on that one.
All the best,
Carol
Berlin, Germany
- Status
Similar threads
- Locked
- Question