Protecting cells in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

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

Adding records to a table 18
Append current record from one table to another 11
Data Mismatch in Excel 2010 4
Append Queries in 2007 5
Append Tables 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Using the latest date in a table as criteria 4
Parameter Value error in a Subform 0

Back
Top