On 1 Apr, 16:57, Golfinray <Golfin...@discussions.microsoft.com>
wrote:

Data in queries cannot be updated for many many reasons, here are some
copied and pasted from the help file:

Query based on three or more tables in which there is a many-to-one-to-
many relationship
Crosstab query (crosstab query: A query that calculates a sum,
average, count, or other type of total on records, and then groups the
result by two types of information: one down the left side of the
datasheet and the other across the top.)

SQL pass-through query (pass-through query: An SQL-specific query you
use to send commands directly to an ODBC database server. By using
pass-through queries, you work directly with the tables on the server
instead of having the Microsoft Jet database engine process the data.)

Query that calculates a sum, average, count or other type of total on
the values in a field, or an update query that references a field in
the Update To row from either a crosstab query, select query (select
query: A query that asks a question about the data stored in your
tables and returns a result set in the form of a datasheet, without
changing the data.), or subquery (subquery: An SQL SELECT statement
that is inside another select or action query.) that contains totals
or aggregate functions
Union query (union query: A query that uses the UNION operator to
combine the results of two or more select queries.)

Query whose UniqueValues property is set to Yes
Query that includes a linked ODBC (Open Database Connectivity (ODBC):
A standard method of sharing data between databases and programs. ODBC
drivers use the standard Structured Query Language (SQL) to gain
access to external data.) table with no unique index (unique index: An
index defined by setting a field's Indexed property to Yes (No
Duplicates). A unique index will not allow duplicate entries in the
indexed field. Setting a field as the primary key automatically
defines the field as unique.), or a Paradox table without a primary
key (primary key: One or more fields (columns) whose values uniquely
identify each record in a table. A primary key cannot allow Null
values and must always have a unique index. A primary key is used to
relate a table to foreign keys in other tables.)

Query that includes more than one table or query, and the tables or
queries aren't joined by a join line in Design view (Design view: A
window that shows the design of these database objects: tables,
queries, forms, reports, macros, and data access pages. In Design
view, you can create new database objects and modify the design of
existing ones.)

Calculated field (calculated field: A field, defined in a query, that
displays the result of an expression rather than displaying stored
data. The value is recalculated each time a value in the expression
changes.)

Field is read-only; the database was opened as read-only or is located
on a read-only drive
Field in record that has been deleted or locked (locked: The condition
of a record, recordset, or database that makes it read-only to all
users except the user currently modifying it.) by another user