Giving permissions in MS Access

[voyz02]

¡Hi!

First of all, sorry if my english level isn't very good... I have a MS Access database with a main form, who want to protect sometimes read/write operations. In particular, I want the users have rights to insert records into the form, and then only have read/query permissions for the records they have been inserted, and can not see that have been inserted by other users.

Is this possible in Access?

Thank you, Greetings!

 

[mcclunyboy]

Hi,

Which version of MS Access is it?

In prior to Access 2007 I have used windows authentication, password protected forms and user account control in access.

In Access 2007 I simply give some users a password which enables them to access different forms. I.e Admin form, Managerial form and user form. Each with its own set of controls.

 

[voyz02]

Hi!

I work with MS Access 2003.

Greetings