I need to implement user authentication in ms access 2007 application. I need to create user roles and permissions to wirte some records , but not only to read from other records. Also, I would like to track which user modified record.
I have a multi user ms access application with back end on SQL server 2008, but i need to implement security on ms access not in sql server. Any suggestions or may be vba code samples?