Help i did something stupid!

[amaztheking1]

Hello i did something very stupid. I was trying to put a password on my database on ms access 2007. I did some random thing and know everytime i open my databast i get this message
You do not have the necessary permissions to use the <location> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)

Ive searched everywhere to fix this but no use.

Can you please please help me.

 

[Nilay]

I'm not sure it will work, but you can try this : Create a new blank database, import all data and structure of the damaged database in to this one. If something has happened which is specific to that damaged database, what you'll have at the end is a copy of that database.

 

[amaztheking1]

i cant open the damaged database so i cant copy it.

 

[Dennisk]

The default workgroup file probally has a user ID in it, plus a password.

Do you have an IT dept? if so why not request a restore of your DB, you do keep backups, don't you. Or re-install Access, this will create a blank default workgroup for you then try open your db.

 

[amaztheking1]

It does have an id and password but there is no where to enter it. I'm at home and it is for a school project and im on my half-term holidays. I'll try reinstalling office but is there anything else i can do in the mean time

 

[Kafrin]

It sounds like you might need to open the database through a shortcut. You do this if you have created an .mdw file when setting up your security, and it allows you to have multiple usernames with different settings for each. The easiest way to do this is to start from a shortcut to Access (if you drag Access from your Start menu to your Desktop and hold Ctrl when you let go you'll get a copy of the shortcut).

Then right click the shortcut and go to Properties. On the shortcut tab find the Target box. Click in it and go to the end of the text that's there, then type a space, quote marks, then the full path and name of your database (including .mdb at the end), then quote marks again and another space. Next type [/wrkgrp] (without the brackets), a space, quote marks, then the full path and name of your .mdw file (including .mdw at the end), then finally more quote marks.

---"Full path and name" means the full location of your file, eg, C:\MyFiles\MyDatabase.mdb

You should end up with something like:
"C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.exe" "C:\MyFiles\MyDatabase.mdb" /wrkgrp "C:\MyFiles\MySecurityFile.mdw"

Click OK to close the Properties window and you should now be able to open your database by double-clicking the shortcut, which will give you the chance to enter your username and password.

 

[amaztheking1]

thanks alot for tying but i have no .mdw file. I searched for it, but there is none.

 

[ByteMyzer]

Try looking in:

C:\Documents and Settings\MyWindowsUserName\Application Data\Microsoft\Access\

...for a file named system.mdw

(NOTE: substitute MyWindowsUserName with your actual Windows User Name)

 

[boblarson]

And a BIG lesson learned here (which I also learned the hard way about 11 years ago) - ALWAYS make a copy of your database BEFORE doing anything to it.

 

[amaztheking1]

i've found the .mdw file, i tried it but it doesn't work

 

[Dennisk]

Did you do as a poster sugested and created a short cut in the format

PathToAccess PathToDB /WRKGRP PathToWorkgroup

or you can join the workgroup by opening the workgroup manager, then try to open the db.

 

[amaztheking1]

yes i did what poster suggested and where is the workgroup manager?
​

 

[Dennisk]

Access 97 store the workgroup manager here

C:\WINDOWS\system32\WRKGADM.EXE

other versions store the .exe elsewere, so search.

Versions greater than 2003 ( I may be wrong here) have the workgroup manager as a component that can be called directly from the access dev environment, proballby from the tools menu.

 

[amaztheking1]

Take alook at it urself http://www.megaupload.com/?d=JUOZN0GO

Please can u download it and fix it.

 

[ByteMyzer]

Have you considered consulting a Database Repair Service? One can be found here: Home > Services > Database Repair

 

[amaztheking1]

how long do they take to reply?

 

[ByteMyzer]

Click on the link to find out.