Protecting cells in a table

H

Hawksby

Is there a way of producing a select query and only allowing the user to
amend certain criteria? At the moment i'm having to append my data to
another table and then querying that.
 
J

Jeff Boyce

A potential confusion of terminology ... Spreadsheets have cells, Access
tables don't.

Access tables have records (rows) and fields.

Having users enter/edit data via a query gives you very little control over
what they are doing (or can do). Consider using an Access form for the data
editing.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top