J
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
record only JSmith could modify the record?
Thanks Ms. Jen
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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.
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.
J
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
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
K
Keith Wilby
Jen said: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