Form with an Inner Join Query as a Source, recordset is not updatable

However the solution was to change the source to the table, which is not plausible in my current setup.

To further elaborate, my issue is that I have a form, Review, which is using a query, Query1, as it's data source, this seems to be causing the recordset to be non-updatable. The datasource must be a query because I am using a rather complex system to limit the records that the form will show.

If I were to change the source to the table, Input List, the form does function correctly, but does not limit the records correctly.

it contains only test records.

However I am not especially well versed in Access and this is my firstattempt at creating a useful database from scratch.

Sponsored Links:

Related Topics

Creating an updatable query recordset using Access 2010
I am trying to create a recordset in Access 2010 using a query. The query uses global variable that captures the users log-name to filter for the records that they entered. The queryexecutes, but the records are not updatable.

The code uses ADO. My goal is to split this database to create a multi-user environment. The source table has a primary key and there are no calculated fields.

Can someone please explain how I can make this recordset updatable.


Filter a form but keep recordset updatable
I am looking to filter a form but keep the recordset updatable. Here's what I have -

I have a table that I want to be able to update.
I have a query that I want to filter it based on.

When I use the table joined to the query for a recordset, it does exactly what I want except for not being updatable.

What is another way to make the form only display the records I want?

There are 2 fields that need to be married here, VendorNo to APVNDR and InvoiceNo to APINV. A single field will not always produce non-duplicative records, so I would need to test the two of them.


Updating Difficulties
I have run a query from my SQL database and then put the query results into a few columns in my table.

I made a form to be able to go through and fill in other empty fields in that table, but it is telling me the Recordset is not updatable.

What would make a recordset not updatable


Recordset not updatable
When I try to enter data into form I receive "This Recordset Not Updatable".


Updatable Query
Help Text for M/S ACCESS 2003..under topic of..
Create View statement says..
"If the query defined by the SELECT statement is updatable,
then the view is also updatable. Otherwise the view is read-only".

Further,.. Help text for troubleshooting forms under the topic
of unable to update fields says..
"Underlying query or SQL statement for the form may
Not be 'updatable'".

So..
HOW/WHERE do I tell M/S ACCESS that I want the
query to be Updatable?

(Also,.. does this mean that only ONE of the underlying
tables of the query will actually be updatable??.. if, in fact,
I am able to declare the query or Select statement as updatable)


Why does this recordset become not-updatable
I have a form with a multi-item subform. The subform is quite complex and its data source is 5 linked tables - it's working just fine but I would like to make changes in the data so it presents more effectively. All data requiring updating are associated with only 1 table.

The data needs some minor adjustment as part of the presentation so I create an additional table extracting the needed pieces from the original form datasource query then create the newsequencing key using a VBA function created especially for this purpose.

Finally I then modify the original form datasource query to include this new table but as soon as I adjust the form to include the new sequencing field Access declares the recordset un-updatable.

I didn't break any rules that I know of. If I remove the table from the datasource SQL it works just fine but I can't get the sequencing I need without shutting off my ability to update thedata in the one underlying table that needs updating.


Why does this recordset become not-updatable
I have a form with a multi-item subform. The subform is quite complex and its data source is 5 linked tables - it's working just fine but I would like to make changes in the data so it presents more effectively. All data requiring updating are associated with only 1 table.

The data needs some minor adjustment as part of the presentation so I create an additional table extracting the needed pieces from the original form datasource query then create the new sequencing key using a VBA function created especially for this purpose.

Finally I then modify the original form datasource query to include this new table but as soon as I adjust the form to include the new sequencing field Access declares the recordset un-updatable.

I didn't break any rules that I know of. If I remove the table from the datasource SQL it works just fine but I can't get the sequencing I need without shutting off my ability to update the data in the one underlying table that needs updating


Recordset Not Updatable
I am having a problem running a macro which calls on 4 queries. Each one relies on data from the last one, they all seem to run properly except one which displays the message "this recordset is not updatable" down the bottom of the screen.

Anyone know what the problem is here and how I can fix it


Forms not updatable
I have three tables. I have them joined in a query by a UniqueID field.
I can run the query and see all the data.

Why is it not updatable? Through the Query or if I set up a form to point to the Query.

Does this have to do with the way I have the joins set up?

Note: the tables a linked to another Access Database.
If I open the tables individually I can edit them.I just dont know what can be wrong with my Query/joins

Table A (all license)
Table B (Owners)
Table C (alternate owners)

1 to Many relationship/join set up from A to B and A to C


operation must use an updatable query
I am executing a simple update query:

UPDATE tblMatrix INNER JOIN qrySelectMaxDate ON tblAll.SoldTo = qrySelectMaxDate.SoldTo SET tblMatrix.LastInvoicedDate = [qrySelectMaxDate]![MaxOfInvoiceDate];

and I am receiving an error "operation must use an updatable query".
Googled it but not of the explantation seems to be aplicable to my query


updatable query
I just ran a query and MS Access shows it is un updatable query.

If yes, are there any rules that for updatable query?


Recordset not updatable...WHY?
I have a single table in a query with only one criteria. However, when I try to update a field I get the "recordset not updatable." error message. Why?

SELECT AACCUReport.PriEntityID, AACCUReport.TPName, AACCUReport.RACF_No, AACCUReport.Status FROM AACCUReport GROUP BY AACCUReport.PriEntityID, AACCUReport.TPName, AACCUReport.RACF_No, AACCUReport.Status HAVING (((AACCUReport.Status


The Recordset is not updatable
I created a database and splitted it.
I put the backend in a server and sent the front end to the users.
However, the user can't update his records and the form is showing that the recordset is not updatable in the status bar.!

in addition to that, I have a module that connects to the backend dynamically to search for a record. the code is running in my pc perfectly but not running in any of the users showing
run-time error '3051'
stating that the backend database is open exclusively or in read-only mode eventhough I gave the users full permission to the backend.


Record set is not updatable
I am trying to edit my query and keep getting the error Record set is not updatable.

Here is my sql

SELECT Inv.[ID], Inv.[Area], Inv.[Hosting], Inv.[Type], Inv.[Ser_num] FROM Lease INNER JOIN Inv
ON Lease.Serial = Inv.Ser_num;


recordset not updateable
Are only simple select query recordsets updateable?

When I create a form based on a query with even a simple join it wont let me update the recordset.

Is this always the case?


Basic Queries Using QBE
Learning objectives: Do queries contain any data? How do I create a query? What can I do with a query? How do I create a calculated field? Why does Access add square brackets around field names? What names should I give the queries I create? What does the ampersand operator (&) do? What is a non-updatable recordset? How do I tell whether a query results in a nonupdatable recordset? (pdf file, install Acrobat Reader to read this tutorial.)


Recordset not updatable from form
I have a form that worked fine until I added a field from a linked table. I have an append query, "Usage Query1" that finds the max data in a column and places it into a table called "Usage1". This table in linked to my main table called "Measure". I also have an append query called "Usage Query2" that finds the max data in a column and places it into a table called "Usage2". This is also linked to table "Measure". I added a field from Usage1 just fine with no error, but when I add a field from Usage2 I get "This recordset is not updatable" in the status bar when I open the form again. I can still update and add records in datasheet view however just not from the form. What is causing this? I need help ASAP


One to many updatable query table row (KB928023)
In Acc2010 we are experiencing this error with a simple one-to-many updatable query, with the following message:
The current field must match the join key '?' in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table.The query is wrongly attempting to add a new row to the 'one' table when it adds a new row to the 'many' table.

[LINK] acknowledges this as an Acc2007 problem. It says the problem arises if the output list includes a 'complex' field (sic) from the one table. Our output list includes only one field from the one table: a non-complex long integer ID field, with 'Allow Multiple Values' set to False (and no other properties that might make this a 'complex' field).


Using queries to get the information you need
At first glance, it appears that splitting information into multiple tables and relationships creates more of a headache than it is worth. People generally like to have all the information they require on one screen (like a spreadsheet, for instance); they do not want to have to know about multiple tables, foreign keys, relationships, and so on. Saved queries address this problem. Queries allow the user to join data from one or more tables, order the data in different ways, calculate new fields, and specify criteria to filter out certain records. The important thing to keep in mind is that a query contains no data it merely reorganizes the data from the table (or tables) on which it is built without changing the "underlying tables" in any way. Once a query is defined and saved, it can be used in exactly the same way as a table. Because of this, it is useful to think of queries as "virtual tables". Indeed, in the majority of DBMSes, saved queries are called views because they allow different users and different applications to have different views of the same data. Learning objectives: create different types of queries; understand how queries can be used to answer questions; develop a naming convention for queries; understand the difference between an 'updatable' and 'non-updatable' recordset. (pdf file, install Acrobat Reader to read this tutorial)


Fields from Query joined to Table not updating table
I have a table with an equal join to a query. I would like to take a field from the query and update the table, but I get an error message indicating that this is not an updatable query.

The field from the query is an expression based on a diffferent table. I'm not quite sure why this won't update