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 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.

Show quoteHide quote

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

Show quoteHide quote

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

locked out
security only works on my PC
unsafe expressions problems on office 2003 with one user.
Locked Out
AllowBypassKey in Access project
Query Wizard Access
Sharing a Secure Database on a network
encrypt and descrypt
about readonly of excel file.
Startup options