Cleared all users now cant access system? 1

[gerrydavis2000]

Please can anyone shed light onto this:

Using a database in work i went in as administrator and whilst in the userlogins section of the DB i cleared
the passwords. Now this is stoppign anyone entering the database, when clicking on the database it goes straight to a message saying you dont have permissions get admin or creator to give you some. I have tried an system restore and a backup restore but nothing.

The database in question is made of a backend, front end and a security end which is MDW file.

Please any suggestions, i'm very desperate

Thanks

 

[easyit]

Hi,

1) how and where did you cleared the passwords?
2) are the old pwd not working anymore?
3) can anybody enter the db?

EasyIT

 

[gerrydavis2000]

Hi,

1) I was the administrator and in the password database i selected clear password.

2) It doesn't even give you the option to enter a pwd the login screen doesn't appear, just straight from clicking the db you go to the error message.

3) No-one, it seems i've wiped all users from the system!

Thanks

 

[easyit]

...What do you mean with the password database?
With standard security, Access doesn't have a pwd database, unless you mean the mdw. But then, how did you delete the password in the mdw?

Anyway, without the prompt, it usally means that access.exe is opening your secured db without the proper mdw. It is using the standard system.mdw instead of the custom mdw (I hope you still have it!)

What you could try is the following:

1) create a shortcut to the secured database.
2) open the properties (of the shortcut) and change the path in the following:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "complete_path_to_the_secured_db.mdb" /wrkgrp "complete_path_to_the_workgroupdatabase.mdw"

When you open this shortcut, it will instruct access to open the specific db with the specific mdw. You should get a prompt, and be able to login.

note: the path to access.exe could be different on your pc.
EasyIT

 

[MarkatLMFJ]

EasyIT,

I am having a similar issue but a little different, I want to remove the security from a secured database - I want it to be completly wide open, no users, no passwords no nothing, The person who made it was playing around and put security on and now we can't pull it off --- and he did it on a production DB.

Any ideas how to completly remove the security?

ML

 

[easyit]

Markatlmfj,

Yes. You should get into the secured db.
From there create a new db (file, new...etc).
Save it some where, it will become your new unsecured db.
Now you can import (file import etc...) all objects from the secured db into the new one. This is possible, because access.exe is still 'connected' to the mdw file from the secured db, but since it is a new db, no objects are secured.

After you have done this, close access.exe (and the db), and reopen the new db. Check any references in VBA, they are not automatically imported into the new db.

I prefer this over the alternative method. The alternative is deleting the password for the account named "Admin". Doing that also removes the security, but still leaves your db tied to the mdw file (you inherit secured objects....).

EasyIT

 

[MarkatLMFJ]

> Check any references in VBA, they are
> not automatically imported into the new db

Mind elaborating on where to go and how to fix that. I'm a vb.net programmer and MCDBA --- but MS Access is way beyond me, I really don't like using it and this place has a lot of it...and this one pesky secured DB we want unsecured.

ML

 

[easyit]

...in access, press ALT+F11, you enter the VBA window.

goto ...options(? My Access version is Dutch) and references, and set your libraries etc if needend. You can check the 'if needed' by compiling your DB, also somewhere in the menu of VBA (fifth from the left, named "..error.."?).
If the db compiles without erros, there are no references to be set, if there are, you should find out which ones. If you need help with that, please tell me at what instruction the comilpere errors out. I'll br online for another 20 miutes max