Security for a table to be used for an Administrator password.

[djarman]

Hello,

I am trying to keep users from accessing the tables in a MDB file that I have created. I would like to make a password in a small form that I would be able to put a password in that would allow me to change a password in a protected table. Theoretically, this protected table containing the password I could change would be used to allow users to access various functions in the MDE file.

I was successful in putting a password in the form itself, but have not found a way to modify it when in MDE format (which I don't think you can). This made me think of the process above, but I am not sure if it is possible or not.

I tried to implement user level security, but when using another person’s computer (storing the single copy of the file on the network drive) the security did not hold. I am not using an Access server and each person will have this program on their personal office computer. It is intended to be used by individual users, but I would like to have the ability to change their passwords. The password will allow users to change the form autonumber and delete rows from the tables.

Any thoughts would be greatly appreciated.

Dwayne.