Recordset is not updateable. 1

[blally]

I am trying to create a simple query that is a one to one join between two tables. However, as soon as I join the tables the query is Read Only. I need to edit this query in a form. I join has to be an inner join. If I run a query with one of the two tables it can be edited but as soon as their are two tables in the desing view it in Read Only.

What would make a query Read Only?

 

[Robertd]

Hi Blally,

to edit this you need to add both keys to the query,
then if you add data to the master table key field access should add the slave table key field data for you, this usually works.

HTH

Robert Dwyer
rdwyer@orion-online.com.au

 

[Quehay]

Also try changing the recordset type to Dynaset(inconsistent updates). This will allow updating fields that are locked with regular dynaset.