Column Locking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


Brandon Campbell said:
Hello,

I have a client that does not want to use SQL Server as the backend
Click to expand...
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
Click to expand...
prevent a user from opening a table.
 
Back
Top