CODEWITHSUNDEEP
ms-accessvba
Thrys5
Thrys5

Reputation: 71

Locking a column in an access table (Access 2013)

I was wondering how i would be able to lock a column in Microsoft access so it wouldn't be editable in the table. This column would auto fill by a script I have written. From what I've researched this is only possible in forms. I do not want to lock the whole table, just one column.

Thank you

Upvotes: 0

Views: 3727

Answers (1)

nicomp
nicomp

Reputation: 4657

Can't do it. The Access security model does not support attribute-level security.

You could create a separate table that is not editable by your user, then link that table to the editable table with a foreign key.

Upvotes: 1

Related Questions