I have moved tables in a DB to SharePoint and the forms, reports etc all display the correct information. The problem is that when I go to add data in a form, I get the "This Recordset is not updatable" notification.
I have attempted researching the issue on line, but none of the solutions that I can get my head around have worked.
I suspect, but can't confirm, it is related to the Keys used in the Access Tables, noting they are different to that used by the SP list. I have uploaded a defn of one of the tables - one from the SP list and the other from the Access table.
As best as I can tell there is nothing I can do about the SP List using an Autonumber ID as the Key, but there seems to be some work arounds at the client end that can be utilised, but I am not having any joy with that.
Interestingly, the Relationship Diagram had no links showing when I opened the SP version in Access, so I tried creating relationships between the tables using the SP provided ID, but again with no joy.
I CAN edit the tables directly, and effect changes in the SP lists that way, so I do have write permission to the SP Lists.
I get the message when I try to update a record in query datasheet view, and when using a form.
When I try to add a record, I get a popup message - "You can't go to the specified record."
Note that when I hosted the DB locally it all works fine.
Any ideas?
Thanks
joncb
I have attempted researching the issue on line, but none of the solutions that I can get my head around have worked.
I suspect, but can't confirm, it is related to the Keys used in the Access Tables, noting they are different to that used by the SP list. I have uploaded a defn of one of the tables - one from the SP list and the other from the Access table.
As best as I can tell there is nothing I can do about the SP List using an Autonumber ID as the Key, but there seems to be some work arounds at the client end that can be utilised, but I am not having any joy with that.
Interestingly, the Relationship Diagram had no links showing when I opened the SP version in Access, so I tried creating relationships between the tables using the SP provided ID, but again with no joy.
I CAN edit the tables directly, and effect changes in the SP lists that way, so I do have write permission to the SP Lists.
I get the message when I try to update a record in query datasheet view, and when using a form.
When I try to add a record, I get a popup message - "You can't go to the specified record."
Note that when I hosted the DB locally it all works fine.
Any ideas?
Thanks
joncb