Lost Permission

[Guest]

Some how when working on my database security I managed to lose permission to admin on it. Im working on an Access 2003 file and had everything going well; I got a prompt asking for my name and password before, now when I click the link it says that I dont have the neccessary permision to open the object, that I need to get the admin or owner to give me permission. I am the admin and owner! Im lost and frustrated, help!! I dont know what to try or do next. Anyone with some stratagies?

 

[Joan Wild]

Some how when working on my database security I managed to lose
permission to admin on it. Im working on an Access 2003 file and had
everything going well; I got a prompt asking for my name and
password before, now when I click the link it says that I dont have
the neccessary permision to open the object,

Does 'click the link' refer to a desktop shortcut? Are you sure it's the
same one that you used before? The target of the shortcut will have
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
where the mdw is the one that was used to secure the database with.

You are getting the error because you are not using the correct workgroup
file. If you are just double clicking on the mdb in Windows Explorer, you
would be using the standard system.mdw. Use the desktop shortcut that the
wizard created for you.

 

[Guest]

Yes the link I am talking about is the shortcut created by the wizard. I looked at the target path and its just as you decribe, so nothing there looks funny or out of place. I have the one step Security Wizard Report, but not sure if thats of any help for this problem. Any other suggestions where to look at?

 

[Joan Wild]

OK, so it's the right workgroup. Are you certain you are entering the
correct username and password? The password is case sensitive; also don't
confuse the PID for a password - They are not the same.

 

[Guest]

This is the part that confuses me, it no longer even asks who I am. I dont get the login in prompt anymore. Once I click on the short cut Access opens and I immediately get the message that I dont have the permission to get to that object. Somehow it thinks I am not who I am without even asking me for the username and password. So I am not sure what or where to troubleshoot next. Ideas?

 

[Joan Wild]

OK, that means that the password for the 'Admin' user has been set to
nothing (null). Therefore you get no login prompt. So Access is opening
and silently logging you in as Admin, which rightly doesn't have permissions
to anything.

Access should still open (just not your mdb). Go to Tools, Security, User
Accounts and click on the change password tab. You should see 'Admin' as
the user. Set a password for this user.

Close Access and try your shortcut again, this time supplying your
username/password.

 

[Guest]

I am having the same problem that was described in this discussion. However,
the solution is not working for me. I have lost the ability to login and
cannot open any of my secured databases.

I am the administrator, creator and as of now sole user of a set of secure
Access databases. When I try to open a database I receive a message saying
that I don't have the necessary permission. Every once and while the login
box does pop up (I can't figutre out why) but my login infor is not
recognized. Please help! Thank you.

 

[Joan Wild]

I am having the same problem that was described in this discussion.
However, the solution is not working for me. I have lost the ability
to login and cannot open any of my secured databases.

I am the administrator, creator and as of now sole user of a set of
secure Access databases. When I try to open a database I receive a
message saying that I don't have the necessary permission. Every
once and while the login box does pop up (I can't figutre out why)
but my login infor is not recognized. Please help! Thank you.

You are getting that message because you are not using the correct workgroup
file to open the mdb.

I assume you know the workgroup (mdw) file that was used to secure your
databases. Create a desktop shortcut to open them. Put the following in
the target of the shortcut:

"path to msaccess.exe" "path to secure.mdb" /wrkgrp "path to secure.mdw"
Launch your mdb via this shortcut.

If your login info is not recognized, check that your capslock key is set
correctly as the password is case sensitive. Also, your password may be
blank. Try logging in with your username and blank password.

 

[Guest]

Wow, this worked! Thanks so much.

You are getting that message because you are not using the correct workgroup
file to open the mdb.

I assume you know the workgroup (mdw) file that was used to secure your
databases. Create a desktop shortcut to open them. Put the following in
the target of the shortcut:

"path to msaccess.exe" "path to secure.mdb" /wrkgrp "path to secure.mdw"
Launch your mdb via this shortcut.

If your login info is not recognized, check that your capslock key is set
correctly as the password is case sensitive. Also, your password may be
blank. Try logging in with your username and blank password.

 

[Guest]

I am having the same problem with my mdb file.

I set a password for the Admin User. Now I receive a prompt to logon as
the Administrator but the password that was supplied to me does not work.

Please help..

 

[Joan Wild]

I am having the same problem with my mdb file.

I set a password for the Admin User. Now I receive a prompt to logon as
the Administrator but the password that was supplied to me does not work.

Please help..

Are you joined (or using) the correct mdw file?

 

[Guest]

Hi Joan. I also fubarred my secure database.
Here is what I did, and what I have done so far.

First I moved the folder my database was in.
Then I deleted the shortcut on my desktop
Then I emptied my recycle bin (gone for good!)
Then I tried to open the database .mdw file straight from the folder it is
stored in.
*panic*
Then started fooling around with the security settings and passwords etc etc.

I arrived at a point where I was no longer even being asked for my user/pwd.
and almost started to cry.
----------------------------------------------
Then came to this post, fixed the admin with no pwd problem, and now I'm
back to being asked for my password again, but I get the error " you don't
have the neccessary permissions blah blah blah".

From your posts above, I think it's a 'workgroup' problem, i deleted my
original shortcut that the wizard made for me. Am I screwed for good?
Can I make a short cut?

I'm frantic.

 

[Joan Wild]

Of course not. It sounds like you still have your secure mdb and you still
have your secure mdw. You just deleted the shortcut.

So create a new one. Right-Click on the desktop, New, Shortcut...
You can navigate to the location of msaccess.exe and finish the creation of
the shortcut.
Go to the desktop, right-click this shortcut and choose properties.
You'll see the 'path to msaccess.exe' in the target line.
Move to the end of that and modify it so it has the following in it.
"path to msaccess.exe" "path to secure mdb in new location" /wrkgrp "path to
secure mdw"

 

[Guest]

i lose my permissions as admnistrator

I am having the same problem that was described in this discussion. However,
the solution is not working for me. I have lost the ability to login and
cannot open any of my secured databases.

I am the administrator, creator and as of now sole user of a set of secure
Access databases. When I try to open a database I receive a message saying
that I don't have the necessary permission. Every once and while the login
box does pop up (I can't figutre out why) but my login infor is not
recognized. Please help! Thank you.

 

[Scott McDaniel]

i lose my permissions as admnistrator

Do you receive any errors or messages when you try to logon?

Are you still prompted to login? If so, does the username you're logging in with have sufficient permissions to admin
the database? Often this is done by simply including that user in the Admins group (assuming permissions were left in
place on that group), but the original developer could have built a new group which mimics those permissions.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com