locking column values in tables

J

jb

Tables being constantly imported and exported but would
like to know if I can lock selected columns to stop my
users changing the values of fields.
 
D

dave hutchinson

-----Original Message-----
Tables being constantly imported and exported but would
like to know if I can lock selected columns to stop my
users changing the values of fields.
.
Use your tables to create a form and then in form design
Click to expand...
view change the properties of your selected fields/table
columns to "Locked YES". it's not the ideal solution but
it does stop unauthorised editing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Turning a 3 column flat file into a "3D" Table 2
VBA - retrieve data on last create named range from previous inserted named range 0
Turning Data into a Table 1
Excel Can you lock the value of a cell but not the format? 1
Possible to select a string in a locked cell? 1
Access Dynamic/Crosstab Form 0
Access MS access forms list box problems 1

Top