Is there visual basic code which can on file open ask for password and maintain value

[aeiou137]

I am looking for a method when opening a database file which on the load of the opening form will ask for a password. I know how to make the inputbox and messagebox to check for correct or incorrect passwords. Also know how to use if then and else to control what occurs next.

Problem I am trying to fix is having to enter the password more than one time during the file open period.



I would like to be able to open the file enter the password and pass the parameter value between forms to control visibility of certain command buttons, acNormal, acReadOnly ... settings

I am using Access 2010.

[SoftwareMatters]

I have done something similar to this by hiding a text field on the main form (which is always open) and writing the password variable in to the text field. Then the other forms can look at the hidden textbox to decide their formatting.

If you do not have a form that is always open then you could save the password as a public variable or database property or even to a table.