Protect fields in table

T

Teresa

I have a table that users access thru buttons attached to queries. Users
need to input data in certain fields but other fields need to be locked. I
know how to do it if a form is used. However, they didn't want to use a form
(Access freaks them out and the table format looks the most like Excel). So,
how do I lock fields in a table when a form is not being used?
 
J

John W. Vinson

However, they didn't want to use a form
(Access freaks them out and the table format looks the most like Excel). So,
how do I lock fields in a table when a form is not being used?
Click to expand...

You can't.

Use a datasheet form, or a Continuous form mocked up to look like a datasheet.
They don't need to know it's a form <g>...
 
K

Klatuu

What will really freak them out is when their data is totally trashed
because they have put things in that don't belong.

Users should never be allowed direct access to a table.

There is no way to prevent users from editing fields in Access without using
a form.
 
Top