Unanswered: You do not have the necessary permissions to use the <name> object - Problem
I am Active Duty in the United States Air Force stationed in California. Recently our communications guys transfered all of our data from one server to another following that transfer there was a problem with a very important Access file I use.
Now I am pretty good at hardware, decent at most software and a complete idiot with Access. I have done my homework prior to posting though.
I've learned the error I'm getting "You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)" comes up because the Database I am trying to open is secured and apparently I don't have the proper Secure workgroup file.
I realize the easiest fix would be to have the file's owner open the file and correct the problem but being in the Military he is no longer at this base. The second easiest fix would be to use the unsecured .bak file. The .bak file is no-where to be found.
The good news is I was able to find the One-step Security Wizard Report that has the WID.
The db was made in Access 2000 and I currently have Access 2007.
How can I re-create the workgroup file and give myself access?
If you cannot find a workgroups (.mdw) file, then there may be a System.mdw stored either in the Program Files area or the Application Data. It may be that, in the absence, of a specified workgroups file, Access reverts to this default workgroups file. Typically, this file contains a user called "admin" as a default. This is a misnomer as this is not a real administrator at all (though it could be made one).
You could test this hypothesis by creating a new (empty) database with System.mdw as it's workgroups file (look for the Workgroups Administrator option in Tools/Security and apply to "join" the workgroup. After that, you can install other users and groups, mirroring the users and groups in your original database. Then you open the original database with a command line which includes the /wkgrps switch, specifying the new workgroup file.
At the next level, if you want ot make specific objects (tables, forms, etc.) accessible to specific users, you must go to the User/Groups Permissions utility in the same menu. Remember however that these permissions are attributes of the database and not of the workgroups file.
So apparently its the .mdw that is the problem. Double sided question. I understand that I can recreate the .mdw using the One-step Security Wizard Report. When that .mdw is made does it need to be 100% accurate to the origonal or can it have an additonal user added in? The reason I ask is because the two file creators in the origional .mdw are no longer at this base. I have tried making the file but it is not working for me. Would someone be willing to try creating one for me? I am willing to provide a copy of the One-step Security Wizard report.