Bypass database password using VBA code

[DanSmith]

Hello,

The situation is as follow:

I have a database where I put a database password. When you open it you have this little box where you have to enter the password.

I made my own login from with user name and password that open up as popup maximise when the database is open.

What I would like to do is when you open the database, the database password is enter using a code and that the user have access directly to to login form.

You are gonna tell me why do I want a password and that the password is entered automatically when you open the database ???

The reason is that my database is set to have the passwords in a specific table. If the database is not protected, anybody can do a get external data to retrieve the passwords. If my database is password protected they can't. I do not want that people have to enter 2 times their user name and password.

In resume I just would like to have the code that enter the database password automatically when you open the databse.

I have found that you can have a database that will open the protected database but I would like to have that in only one database.

Thanks in advance for your help.

Cheers!
Dan

 

[statsman]

I am not an expert in Access security, but it is my understanding that the Database password in Access has only two choices, On or Off.

There are some entries in the forum regarding "Do It Yourself" passwords. You may wish to do a search and apply one of them to the table you're trying to protect.

 

[KeithG]

I don't think what you want to do is possible. Can you use Group and User permession to assin them the username and password.

 

[DanSmith]

Hello,

Thanks for your answer.

I figured it out. Actually, I use another db to open the password protected database bypassing the database password.

I wanted to have it in the same db in order to avoid to have 2 db but it is not possible to have code before the database password is asked.

Like this it works great.

Thanks !

Cheers

Dan

 

[TeeVee]

Hei Dan,
I have the same question.
Can you give me an update on what you did with your 2 db's?
Did you use VB code when openeing your protected DB?
On one of the other forums nobody had an good solution , it might be that your's is good enough , pls let me know.
Regards
TeeVee