I have been given the task of managing and administration of an Access 97 database. It does not have any kind of security at the moment.
I would like to build a security module to tie into the database that will request the user to logon with an User ID and a password. Based on their ID, I would like to control their access level such as updating, creating, and deleting records but even more important, I want to prevent them from getting into the modification of the design of queries, tables and reports.
I would like to capture this User ID as the person who creates a record, and capture the ID as the last person that modified the record.
What is the best way to do this?
Thanks, for any help in this.
John
I would like to build a security module to tie into the database that will request the user to logon with an User ID and a password. Based on their ID, I would like to control their access level such as updating, creating, and deleting records but even more important, I want to prevent them from getting into the modification of the design of queries, tables and reports.
I would like to capture this User ID as the person who creates a record, and capture the ID as the last person that modified the record.
What is the best way to do this?
Thanks, for any help in this.
John