mswilson16
Programmer
In an attempt to secure my database I have created a security form where the user has to enter a Username and Password. If they do this in-correctly three times then it opens another form “frmContact Admin”.
I have changed the properties of frmContact Admin so that it is model, pop up, it has no border, and also I have taken the shortcut menu away. The only items on the form are two fields "Password" and "Verify Password" (where I enter a password to re-enter the database), and a close button that quits the application. This form will now re-open whenever the database is entered until I enter a password.
I have tested it out on a number of normal users and they couldn’t do anything to re-enter the database. My only problem is that some of the users have a good knowledge of Access and VB so I need to make sure that this form is impenetrable.
Is there anyway that I can stop users changing the properties of the form or closing it down without the use of my command button. Or is there a way where I can make it so that no users can change any properties in the database. But I still need to be able to change everything.
Anyways of making a database more secure are greatful.
Thanxs in advance.
I have changed the properties of frmContact Admin so that it is model, pop up, it has no border, and also I have taken the shortcut menu away. The only items on the form are two fields "Password" and "Verify Password" (where I enter a password to re-enter the database), and a close button that quits the application. This form will now re-open whenever the database is entered until I enter a password.
I have tested it out on a number of normal users and they couldn’t do anything to re-enter the database. My only problem is that some of the users have a good knowledge of Access and VB so I need to make sure that this form is impenetrable.
Is there anyway that I can stop users changing the properties of the form or closing it down without the use of my command button. Or is there a way where I can make it so that no users can change any properties in the database. But I still need to be able to change everything.
Anyways of making a database more secure are greatful.
Thanxs in advance.
