Cleared 'Admin' Password now can't open database

[Guest]

I have a user-level secured Access 2002-2003 database. I was able to access
it this morning, but after clearing the 'Admin' user password can't access
the database, receiving the following:

"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)"

I was successfully launching the database before with a VBScript that I
wrote myself.

Please help!!

VBA Dabbler

 

[Lynn Trapp]

Why did you clear out the Admin user's password? When you did that, you are
causing Access to log in silent as the Admin user and, apparently, you
removed all of the Admin user's permissions.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Hi Lynn,

I thought the 'Admin' account should be removed. I did not touch
permissions for the account, just cleared the password.

I also found out that the 'Admin' account can't be deleted - Access wouldn't
allow it.

However, is there a way to recover from this or do I need to recreate the
database.

Obviously this is an area I need to do some brushup reading on. Any
suggestions?

Regards,

VBA Dabbler

 

[Joan Wild]

Open your secure mdb via your shortcut - dismiss the message about no
permissions.

Go to tools, security, accounts and click on Change password tab. Admin
should be listed as the current user - provide a password for Admin. Since
you used your shortcut, you should be using your secure workgorup file.

Setting a password for Admin is what causes the dialog to show up.

 

[Guest]

Thanks for your reply Joan.

Unfortunately I just got your message, and before you replied, I had already
reconstructed from scratch.

However, I have a followup question on your recommendation....

What would prevent anyone from setting the password for Admin in this case?
Is the database vunerable to unsecured access?

Regards,

VBA Dabbler

 

[Joan Wild]

In your case, you had cleared the Admin password. Therefore you got no
login dialog, and were silently logged in as Admin.

Once you set a password for Admin, then in order to change it, one would
need to login as Admin (with the correct password) and then change it.

 

[Guest]

Hi MS Access gurus,

I did some stupid thing. Tried so many options and get the same error
message as lsited on this post. How do I get rid of it and recover my
database which I just can't access now..

Jodi

 

[Joan Wild]

I think you need to clarify what error message you are getting, and what you
did.

Did you clear the Admin password? Did you restore it as suggested by
earlier posts?

 

[Guest]

I get the same error message as VBA Dabbler is getting. I did set a password
again and also joined the workgroup.

 

[Joan Wild]

So the message you are getting is
"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)"

That doesn't necessarily mean you cleared the password for the Admin user
(which VBA Dabbler did).

In your case, you likely are not using the correct workgroup file (mdw). Do
a search on your computer for all *.mdw files and note their paths.

Open Access and go to Tools, Security, Workgroup Administrator. That will
tell you the workgroup you are joined to by default. It should be the
system.mdw that ships with Access (it's usually found in the windows system
folder, but you'll find it in the list above).

You do not want to set a password for Admin in this workgroup file!. You
need to leave it as is in order for non-secured databases to work.

You need to create a desktop shortcut (if you used the wizard it created one
for you), that has the following in the target:
"path to msaccess.exe" "path to secure mdb" /wrkgrp "path to secure mdw"

Try each of the mdw files you found above.

 

[Guest]

It displays my name in the workgroup file when I open Access. I searched and
joined all the mdw workgroups.

 

[Joan Wild]

You can change the name it displays (it defaults to your windows login name,
but that may not be the same as the Access username).

I'm still not convinced that your mdb is secured. Did you ever secure it?