user-level security form

[Lifeseeker]

Hello,

Could anybody point me in the right direction as to how to go about doing this?

I have multiple forms in this database and different users will have different access privilege.

How do I implement a form-based user level access security feature?

(i.e. user A can only do viewing the report and query, user B can do everything A does PLUS adding and deleting records, etc)

Thanks

 

[Reynastus]

Access has built in security and you could use that.

Tools > Security > User-Level Security Wizard

I've had some luck with that but only at home never at work due to permissions set on the drives at work and not being able to write/access the required locations.

I'm sure there is another way but I'm trying to find that out myself (ie using a log on form)

Hope this helps

Rey

 

[boblarson]

Access has built in security and you could use that.

Only in the Access 2003, and earlier, file format (mdb). Access 2007 and 2010 does not have User Level Security in the new ACCDB file format. So, if that format is being used, you can't use ULS. If ULS is wanted then you would have to stick with the older mdb file format which means you can't take advantage of any of the newer features in Access 2007 or 2010. So choose wisely.