Securing Records by Users

[Jen]

Is it possible to secure records by users. If example JSmith buts in a
record only JSmith could modify the record?

Thanks Ms. Jen

 

[Joan Wild]

Yes it is. You'll need to study up on security. It is a bit of a learning
curve, and you need to take the time to do it right. Once you've
implemented security, you can make use of the CurrentUser() to return the
Access login name and assign it to the record. You can then use the
function as a criteria in a query to return only that user's records.

 

[Joan Wild]

Hit send too soon.. Some resources:
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

 

[Keith Wilby]

Is it possible to secure records by users. If example JSmith buts in a
record only JSmith could modify the record?

Thanks Ms. Jen

Yes. You would have to record the user's identity when the recrod is
created and test for it in the form's Current event, then set the Allow Edit
property accordingly. Check out the CurrentUser function in the help.

Regards,
Keith.
www.keithwilby.com