Password to Modify an Access 2000 Database

[KEKeogh]

Hi all.

What I want to do is have people be able to view an Access 2000 database but ONLY those with a password be able to modify it. Like in Excel and Word.

I know I've seen methods using user groups and such but our problem is that for the most part everyone uses the same logins. Strange I know but not my doing.

I found the spot in the Tools-Security to set a password but that makes it password protected for anyone wanting to even look at it, which would work in a pinch.

Is this do-able?

Kathie

 

[bob fitz]

Hi Kathie

Other members of the forum with more experience than myself may be able to suggest something better, but you may like to try this:

Create a table (tblUsers) to store the names and passwords of your users. This table should also include a Yes/No column (CanEdit).

In a General Module, declare a global variable (g_blnCanEdit).

Create an unbound form (frmLogin) which opens when the db is opened. Create a combo box, with 3 columns, on this form that will show all the entries in tblUsers. Show the Names column but hide the Password and CanEdit columns. Create a text box (txtPW) on the form for the users to enter their password. In the AfterUpdate event of the text box check that the password entered matches the password in the hidden column of the combo box. If it matches, set the value of the global variable (g_blnCanEdit) to that of the CanEdit column.

Put a line of code in the OnOpen event of each form that sets the forms' AllowEdits property to that of the global variable (g_blnCanEdit).

 

[CBrighton]

If you don't want to propose adding new signons (and specifically passwords for users to remember) you could simply pull the name of the windows login.

Unless they don't have unique windows logins either!

 

[KEKeogh]

Thanks for both of your solutions.

When I talked with the others in the group about the solution I originally found and that I was waiting to hear what this forum had to say, they liked my original solution first.

They liked the idea that the information was only viewable by those that needed to edit the information. So I created one password for those that need.

Thanks for the help though. They may yet come in handy for my personal work database.

Kathie