I was the owner of the access database. and now the owner is unkow
- From: tariq <tariq@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 10 Jul 2006 22:04:01 -0700
i lose my permissions as admnistrator
"Nicolle" wrote:
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" wrote:
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.
--
Joan Wild
Microsoft Access MVP
Robert Ponce wrote:
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" wrote:
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.
--
Joan Wild
Microsoft Access MVP
Robert Ponce wrote:
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" wrote:
Robert Ponce wrote:
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.
--
Joan Wild
Microsoft Access MVP
--
Joan Wild
Microsoft Access MVP
- Follow-Ups:
- Re: I was the owner of the access database. and now the owner is unkow
- From: Scott McDaniel
- Re: I was the owner of the access database. and now the owner is unkow
- Prev by Date: Re: Installed updates, now macros don't work!
- Next by Date: Re: Capturing Windows Login
- Previous by thread: Re: Preventing users opening backend
- Next by thread: Re: I was the owner of the access database. and now the owner is unkow
- Index(es):
Relevant Pages
|
