Security

[samuvk]

I have a database with a a Security System. I have a file with all the users and all the groups. I have a form to ask for information to users. So when anyone open the database, Access ask for user and password, then if you are in the list of user, you can get into the database. Now you find a form to introduce some information, with comboboxes, texboxes, etc.

Now I have two questions:

1. There is any way that I can store each time that a user introduce a record in my database, who was the user that introduce that record and the date when he introduced it?

2. There is any way depending of the user of group he only can access to determinate information. Example. I am a user from the marketing deparment, so after log in into the database, in my form I only can select in the deparment combobox --> marketing. (All the deparments that appear in the combobox are store in a table)

Thank you very much for your help

 

[ghudson]

1) Yes, search for Audit Trail, lots of other threads asking same question.
2) Yes, you need a field in the table that stores the group the record belongs to then you can filter the records based on the users group.

If your database is really secured, then nobody should be able to import your database objects into a new database or link their database to your tables. I doubt that you can prevent that unless you are using Access workgroup security. Just pointing out that your database might not be as secured as you think.