Column Locking

[Brandon Campbell]

Hello,

I have a client that does not want to use SQL Server as the backend database. However, they want to have column level locking. The only way that I know how to create a column level lock in Access is to put those unique columns into a separate table and then restrict access to those tables.

I know that I could enable or disable a field in a form, but that doesn't prevent a user from opening a table.

Is there a feature that would prevent a user from opening a table in datasheet view???

Thank you,

Brandon

 

[Lynn Trapp]

If you implement User Level Security and give your users RWOP queries for
only the data that you want them to have, then you will have column level
security. Get a copy of the Security FAQ, read it several times, and follow
it to the letter. There is a link to it on the Security page of my website.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Hello,

I have a client that does not want to use SQL Server as the backend

database. However, they want to have column level locking. The only way that
I know how to create a column level lock in Access is to put those unique
columns into a separate table and then restrict access to those tables.

I know that I could enable or disable a field in a form, but that doesn't

prevent a user from opening a table.