password help
- Thread starter byron09
- Start date
You mean HE created the passwords before he left and now you can't get into the db - or you just want to change the passwords so he can't get in anymore?
If you are still able to open the database and view all the objects and their design - you can just create a new (blank) database and import all the objects from the locked database.
If you are still able to open the database and view all the objects and their design - you can just create a new (blank) database and import all the objects from the locked database.
Last edited:
Can you still use the database? Can you look at the design of all the objects? Do you have to enter a user id and password when you open the database? What exactly are you not able to do? Does the database need to be secure?
Just try this and see if it works:
Open up microsoft access (not the database in question) and click on "create new file" - or open the "file" menu and click "new" - then click on "blank database".
Once it opens, go to "File", "Get external data", "Import" - then select the database that's locked. When the import wizard opens, go through each tab and select every object. Then import it. If you're able to import every object in the database, you should now have full control of the database.
If you're automatically prompted for a user id and password when you open Microsoft Access, you're going to have to create/join a new Workgroup before you import the other database - otherwise you still won't have administrative rights to the db.
Go HERE to learn how to do that and a little more about access security.
Just try this and see if it works:
Open up microsoft access (not the database in question) and click on "create new file" - or open the "file" menu and click "new" - then click on "blank database".
Once it opens, go to "File", "Get external data", "Import" - then select the database that's locked. When the import wizard opens, go through each tab and select every object. Then import it. If you're able to import every object in the database, you should now have full control of the database.
If you're automatically prompted for a user id and password when you open Microsoft Access, you're going to have to create/join a new Workgroup before you import the other database - otherwise you still won't have administrative rights to the db.
Go HERE to learn how to do that and a little more about access security.
Last edited:
I did that. The following message comes up "Microsoft helps protect this Visual Basic for Applications Project with a password. You must supply the password in tehe Visual Basic Editor before you cab perform this operation".
- Local time
- Today, 13:58
- Joined
- Sep 12, 2006
- Messages
- 16,121
ask him for the password
legeally, he should give it to you
legeally, he should give it to you
Similar threads
