Recordset not updatable

[patpetro]

I created two spreadsheets in Excel and imported them as tables into Access. No changes can be made in Access to these tables. All updates done in Excel automatically update in Access.

I created a third table directly in Access. I used this table and the other two tables to create a form, but the form is not usable. It will not allow me to add anything to the blank fields on the form. Error is "recordset is not updatable."

The Excel spreadsheets/tables do not have primary fields and there doesn't appear to be any way to add primary fields AND import the spreadsheets so that updates in Excel automatically update in Access.

Any thoughts on how I can fix this problem would be greatly appreciated.

 

[HiTechCoach]

Try putting the Access table you want to update in a sub form where the record source is only the table you want to edit.

 

[WIS]

The Excel spreadsheets/tables do not have primary fields

I think that this is where your problem lies. If you are using more than 1 tbl, and tbls are joined, then you can only update where there is only 1 join fld which isn't Indexed, Duplicates Allowed - every other join fld has to be Indexed, No Duplicates. If there were 2 tbls and no Join fld you would get what I think is called a "Cartesian co-ordinate" ie 3 records from tbl1 and 5 records fro tbl2 would give you 3 X 5 = 15 records and so would not be updateable.