What is the best way to handle controlling user read/write access?

[ncsthbell]

I am working on a new database in MS Access 2007 and I want to be able to test a user Id when entered
and determine if the user has read only access or read/write access. I will maintain a user table with these indicators. Is there some way to set a 'database' option or something similiar that would apply to every form/datasheet in the database and set them to read only or does it have to be done for each form?

Any suggestions would be a great help. I want to make this as simple as possible.

THanks

[Chad Reasons]

you can use the built in security wizard to set user permissions.

[mshmyob]

Since AC2007 removed user access security (you now need to use Sharepoint services) you will have to do some programming.

cheers,

[ncsthbell]

It will probably be easier and less complicated to change the properties for the forms based on the user then integrating Sharepoint. But thanks for the input!

[mshmyob]

That is why I said you will need to do some programming. I obviously was not clear. I assumed implementing Sharepoint was not going to happen so I was trying to say you will need to do programming and create some kind of user login system (AC2007 does not use the old security) and then lock controls/forms based on your own login system.

Sorry for the poorly worded response.

cheers,

[ncsthbell]

Your right... I did not interpret your response correctly. Thanks for taking the time to reply. I am going to do the logic in the program to control the user access. Was hoping that I could do it at some sort of higher level than per form. Thanks again.