Protect fields in table

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?

On Wed, 29 Oct 2008 13:04:03 -0700, Teresa
wrote:

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?

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

John W. Vinson [MVP]

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.

"Teresa" wrote in message
...
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?