Recordset not updatable

[Robin]

Hi,

I'm pretty new to access so i think this should be easy
for you experts out there.

All i'm doing is importing 2 different spreadsheets from
excel.
Then i want to make a query which takes selected data from
each sheet.
I have made each excel spreadsheet into a table in access.

I can create the query easily enough but when i combine
data from the two different tables i am unable to update
any fields and the error i get is 'Recordset not
updatable'.

The 'help' shows 'You executed a query that combines
updatable and nonupdatable TableDef objects'.

Well each one is fine on it's own - so how are they now
combining updatable and non updatable data?

Each table is related in 3 fields only.

Help much appreciated.

 

[Ken Snell]

Post the SQL of the query that you've created. That may help us see why it's
nonupdatable.