you cannot reference rows created when you are disconnected from the server because this violates

Question

Greetings everyone, sorry in advance for my wierd English.

So here is the problem, I had  a linked table from Sharepoint into Access ( Ialso make sure that i have all the permissions and stuff)

At first when i open the linked Sharepoint list everything appears as "#deleted" I click on Refresh all and this fix it, then I attemp to modify any cell and that error pops out  "You cannot reference rows created when you are disconnected......"

This SP list only have 2k rows, When I tried to open it again in other access sometimes it shows less records and when I try to modify anything its says " Cannot update Databa or object is Read-Only" error in a query against a linked sharepoint view if there are unliked lookup fields in Access etc..."

Ill forever appreciate any help to solve this problem, Regards.

Answer 1

Hello Alexbas90,

How do you modify the cell? Will it be an issue related to  data integrity?

Please check if below similar thread helpful for you.

Cannot update a SharePoint list from MS Access 2010

MS Access - problem to update sharepoint list with local table

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

I modify the cell the simple way, just as a test I just add a letter in a text field thats what I do to test this way to edit the sharepoint information.

Ok it may be a data integrity issue but if this is the case what would you recommend to detect this issues?

Answer 3

Still cannot Solve this Problem  I've check everything so far as follows:

Open The Database with the Design View, and check every field where the data field is different from Short Text, but I couldn't find anything breaking  a field format... like a letter on a number or date field for example... any ideas on how to run this check ? is there any other direct way to detect inconsistency on my DataBase?

Please Im still desperated to solve this problem, Thanks to any who takes the time to respond.