Recordset not updatable

  • Thread starter Thread starter Robin
  • Start date Start date
R

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.
 
Post the SQL of the query that you've created. That may help us see why it's
nonupdatable.
 
Back
Top