Hello all, I am having a large issue with Microsoft Access. It appears that someone has added security permission to the database that I can not remove. There are two accounts set up, jhyat (myself) and admin. I should be the owner of the objects in the database, but am not, and no account has administer permissions or ownership of any of the objects in the database. HELP!!!!
First check if you are part of the admin group. If you do then you can go into
Tools --> Security -->User And Group Permissions. THere you can then change the ownerships.
I checked the persmissions, the admin group is empty. Neither account that is set up has administer permissions. I tried to make a admin account (named it "bob") and I was unable to give admin permissions because I was not an admin...
I logged in as jhyatt (which is part of the admin group) and I tried to change the ownership of one of my forms. An error message came up and told me that in order to change ownership, I needed to have administer permissions to that form. I tried to add administer permissions, and another error message came up and told me that I needed to be in the admin group to add administer permissions to a form. So I logged out...
I logged back in as admin (also a part of the admin group) and repeated the process with the same results.
Okay now what you can do is to hose the whole security file, create a new security file, set up accounts properly remember to add your id to the admin group and then attach that security file to your db.
Then you will be able to do the owneship change. Let me know if you have problems making another security file.
Well security file is just another file with the extension mdw.Normally the name goes like system.mdw. There is a another program called wrkgadm.exe in your c drive. Run it. this is a security file admin. There you can create a new one (say App.mdw). Then use a shortcut to open up your app. Once you have the short cut. go into its properties and replace the target like that
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\My App\App.mdb" /wrkgrp "C:\My App\App.mdw"
Now open up your app using this new modified shortcut and then change whatever you want to.
make sure that the app has a database password so that when you open your app through this shortcut login id box pops up. Enter your admin account id and now you will login as admin and can change whatever.
Got it. if not then let me know. Now I'm going home, its getting late up here.
That is exactly what I need to do! Thank you for your help!
Unfortunately, I think my computer hates me...
I followed the steps you provided for me but I received an error when I opened the WRKGADM program. The error read: "Can't open registry database". I went to MSDN and found a Knowledge base article that addresses that exact problem, and followed all the direction to resolve it, but it did not resolve. I tried to open the program on three other boxes and all three, including the first, gave me the same error.