CODEWITHSUNDEEP
ms-access
user969113
user969113

Reputation: 2429

Protect existing entries in an Access database

I am completely new to Access and have only limited database knowledge. Is it possible to lock/protect an entry made by a specific user so that other users cannot change that field/entry again? Is there also a way to see which user entered the data in that particular field?

Upvotes: 1

Views: 171

Answers (2)

Gord Thompson
Gord Thompson

Reputation: 123809

Access does not have the security mechanisms to do what you describe. Even the older - and now deprecated - "User-Level Security" mechanism for Access .mdb files (mentioned in another answer) does not allow you to fully protect entries at the row level.

An earlier question here

How can I get my Access form to prevent editing of a field once saved?

talks about how to offer such protection from within an Access form, but it does not address the possibility of a user directly opening the table and editing it that way. As such, that question is merely asking for a "convenience" feature to help prevent users from inadvertently changing something. A forms-based control mechanism does not offer complete security.

If you need more robust security (e.g. for audit purposes) then you will need to use a different database back-end. You could still use Access to build your forms and reports, but they would operate on ODBC linked tables to a more sophisticated database engine like SQL Server (or similar).

Upvotes: 1

Tim
Tim

Reputation: 766

Yes, but I suspect you have a steep learning curve ahead - here's your jumping-off point :)

http://office.microsoft.com/en-gb/access-help/about-user-level-security-mdb-HP003070410.aspx

Upvotes: 0

Related Questions