Aug 6 2004, 02:48 PM
I am a newbie to ACCESS - using ACCESS 97
I copied several tables from another ACCESS database and then created several simple queries. I use no forms or reports. When executing the query I get the message "The Recordset is not updatable". I've looked in search and the only stuff I've found (that I can understand) talks about forms and reports. There are no visual basic or macros that I am aware of.
Ideas? Thanks -
Aug 6 2004, 03:26 PM
Go to the query properties and change the recordset type from Dynaset to Dynaset(Inconsistent Updates).
Aug 6 2004, 05:05 PM
Thank you - that did the trick.
NOW can you or someone either tell me what this did and why - or point me to a resource that explains it in English (somewhat non-technical).
Aug 10 2004, 10:36 AM
This is from Access Help -- about when records can't be updated -- first will be the type of query and the second part will be based on whether or not you can update the data in any manner. Other than posting this information for you I don't know what to tell you.
Query or query field Solution
Query based on three or more tables in which there is a many-to-one-to-many relationship Though you can't update the data in the query directly, you can update the data in a form or data access page based on the query if the form's RecordsetType property is set to Dynaset (Inconsistent Updates).
Crosstab query None
SQL pass-through query None
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, or subquery that contains totals or aggregate functions By using a domain aggregate function in the Update To row of an update query, you can reference fields from either a crosstab query, select query, or subquery that contains totals or aggregate functions.
Union query None
Query whose UniqueValues property is set to Yes None
Query that includes a linked ODBC table with no unique index, or a Paradox table without a primary key None
Query that includes more than one table or query, and the tables or queries aren't joined by a join line in Design view You must join the tables properly in order to update them.
Calculated field None
Field is read-only; the database was opened as read-only or is located on a read-only drive None
Field in record that has been deleted or locked by another user A locked record should be updatable as soon as it is unlocked.