Protect fields in table

  • Thread starter Thread starter Teresa
  • Start date Start date
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?
 
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>...
 
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.
 
Back
Top