Secruing tables for different user groups

[Swillsy]

Securing tables for different user groups

Hi all,

I have a database with 3 levels of users - wardens,admin,managers

I would like the wardens to be able to view the everything however only be allowed rights to modify records in certain tables.
Is this possible in access - had a quick search but couldn't find much

Thanks

james

 

[Pat Hartman]

you would need to use User Level Security (ULS) to do this which is only available in A2003 and earlier. It is not available in A2007 unless your database is in .mdb format rather than .accdb format.

Before you attemt ULS, search here or in the MS kb for "security FAQ" and read the paper carefully. Make several backups of your database, and then make a few more for good measure. Follow the directions in the FAQ exactly. Oh, did I mention backups?

 

[Swillsy]

Oh, did I mention backups?

Yeah, I was wondering why I couldn't do this. What I have ended up deciding to do was to build a seperate front end with different forms for the wardens to use. Thanks for your help though