Password specific forms

Is this a split database? If so, why not simply have two different frontends. In the one for the "common folks" set all forms to read-only.

For the form goto Properties - Data and set AllowEdits, AllowAdditionsAllowDeletions and to No.

And you're correct, Access' native security is a mare's nest!


Linq ;0)>

I agree with you that Access Workgroup security is very cumbersome and I don't use it. I had to solve a problem like yours in the past and what I did was to create two versions of the forms, one of which was read-only (set Allow Edits, Allow Additions and Allow Deletions all to 'No' in the Data tab of the form properties. Make this the default form and have a second copy with these set to Yes which is only accessible when the user enters a password.

(I'd suggest an Update button on the default form which would open a password dialog. Entering the correct password will open the updateable form, if an incorrect password is entered open a messagebox to this effect).

If you'd like to see the code let me know

Good luck!

ha ha! Looks like I touched a raw one with Access security, eh?! In the last version of the DB I'm working on I remember spending a great deal of time going round and around learning how the 'security' worked.

The database is split: can you post your code for me Barry07? i'd be most grateful. I thought of the second frontend idea Linq, but just wonder about the complexities and performance issues? have you tried that idea in the past?

Thanks for all your hel, folks. Just knowing others are/have tackled the same problems is a real comfort as I'm sure you're aware!

Thanks again,

Stonward the Comforted

Suppose you have a button lablelled UPDATE in the standard (read-only). form. The click-event for this button opens a password-input form ("frmPassword") which has one text box only. On the DATA tab of the properties for this text box set Input Mask to password so that the password is displayed as "******" as the user enters it.

The code for the click-event would read as follows

The code in the password-input form will read
In accordance with the Good Practice standards advocated by this group you should define the actual password as a global constant in a code module, so you only have to change it once:

Don't hard-code it in the form.

Thanks Barry07!

Have a great day, people.

Later,


stonward