Query - Recordset is not updateable (1 Viewer)

[kevnaff]

Hi All.

I have a subform called ContractsEditSubform that is based on a query called QueryContractsSubform. It had always worked completely in my .mdb used in Office 2010. Due to an IT update to Office 365, I imported the database in to a new 64bit .accdb. Since doing so, it says that my recordset is not updateable.

Here is the query that the subform is based on:

As you can see here it does not allow any new records to be added:

In the query, if I remove the ImportEquipment table, I am now able to add new records, however I lost a lot of the data fields in my query that relate to the ImportEquipment table.

Does anybody have any suggestions as to why this query has stopped working?

Thanks in advance.

 

[Ranman256]

depending on links in the query, not all tables are updatable.
You may need to change your query with less tables.

 

[bastanu]

Are both fields (CodeNo and Code No) indexed? You might try to change the recordset type to Dynaset (inconsistent updates) in both the query (in design view\properties\recordset type) and the (sub) form.

Cheers,