Add a password to my database. Send him in another database if he fail

[jorge1383]

Greetings to all
I hope someone can help me. I dont know if what i ask is possible.
I want my database to have a password but i want also and something else.
If the user fail to dial the right password to close it and open for him a different database.
I hope someone can help me with that. Can be happen with the encryption password?

Thank you in advance

 

[Trevor G]

perhaps create a table with the database name and path, also the users details and passwords you associate with access rights, then use a form that will use a drop down to select the person details and then ask them for the password if it fails then use an if statement to close and then open the second database.

What is your Access knowledge like, could you tackle this or do you need an example?

 

[jorge1383]

My knowledge in access is quite limited. I would be very very greatful if i could have an example.
Thank you a lot for your help.

 

[Trevor G]

Attached sample database, I have a table named tblStaffPassword which list Staff Name and Password (Password not encrypted if this works change the Field property to have a Mask in the properties and set the mask to Password.

On the Start Form you click the drop down it then shows the Staff Names, and once you select it places the password into a text field if you match the password in the text box below it will open the form else it will show a message box and then display the second database.

If this works for you then on the form you hide the textbox which shows the Password when you click the drop down.

In the VBA code behind the button it opens the staff form or runs the Open other Database code which you will have to change to the correct database and its path. Give it a go and provide some feed back and questions.

Attached is sample.

 

[jorge1383]

I tried your example which is very close to what I look for.
When I put the destination of the database it opens the laccdb file but not the database itself.
Is it because can't be open two databases at the same time?

 

[Trevor G]

What I have added is to open another instance of Access so you can show 2 databases in this method. There must be something that isn't correct as the code I added does open a second database as I have tested it, perhaps show the code you are now using and also give some information about the database location and anything that might help me understand what you have tried.