If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query (Recordset) is Not Updateable
I have a query that has a single table linked one-to-one to two other
tables. I want to update a field that exists only in one of the tables. This field is not generated by code or filled in by the query. Apparently, I can't update anything. What makes the fields in a query not updatable? Is it possible to redo the query so that I can change this data? |
#2
|
|||
|
|||
Query (Recordset) is Not Updateable
In Access Help type the following in the Answer Wizard tab
When can I update data from a query In the results window select About Updating Data and select the appropriate option. If you cannot edit the data in a query, this list may help you identify why it is not updatable: --Query based on three or more tables in which there is a many-to-one-to-many relationship --Query that includes a linked ODBC table with no unique index or a Paradox table without a primary key --Query that includes more than one table or query and the tables or queries aren't joined. --It has a TRANSFORM clause. A Crosstab query is always read-only. --It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause. Queries that aggregate records are read-only. --It has a GROUP BY clause. A Totals query is always read-only. --It contains a DISTINCT predicate (i.e.; Unique Values is YES in the query's properties.) --It involves a UNION. Union queries are always read-only. --It has a subquery in the SELECT clause. --It uses JOINs of different directions on multiple tables in the FROM clause. --The fields in a JOIN are not indexed correctly: there is no primary key or unique index on the JOINed fields. --The query's Recordset Type property is Snapshot. Set Recordset Type to "Dynaset" in the query's Properties. --The query is based on another query that is read-only (stacked query.) --Your permissions are read-only (Access security.) --The database is opened read-only, or the file attributes are read-only, or the database is on read-only media (e.g. CD-ROM, network drive without write privileges.) -- Access 2007: The query calls a VBA function, but the database is not in a trusted location so the code cannot run. Also see http://allenbrowne.com/ser-61.html '================================================= === John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County '================================================= === LA Lawyer wrote: I have a query that has a single table linked one-to-one to two other tables. I want to update a field that exists only in one of the tables. This field is not generated by code or filled in by the query. Apparently, I can't update anything. What makes the fields in a query not updatable? Is it possible to redo the query so that I can change this data? |
Thread Tools | |
Display Modes | |
|
|