Is there a way to limit who can edit saved entries? I have a shared
database. I would like only to allow the person that created the entry to be
able to edit it. Is this possible? I am using Access 2003.
Not easily. You will need to implement Access workgroup security. Download the
Microsoft Access 2000 Security FAQ:
http://support.microsoft.com/kb/207793/en-us
Print it out. Read it carefully. Get a good night's sleep; read it again, even
MORE carefully.
Assign each user their own ID and password. Insist on strong passwords, and if
you see anybody's password on a Post-It(TM) note on their keyboard or monitor,
pull it off and throw it away and reprimand them.
Include a field for the user ID in each table that you want to constrain in
this way. Use the security instructions to lock the table so that none of the
users has even *read* permission on the table; instead, create Queries
referencing the user ID and give them permission to edit only these queries.
It's possible, but it's far from trivial.
