I have a query in MS Access 2010 to update a SharePoint list that I have linked. However, it will not update giving the following error message: 'You cannot reference rows created when you are disconnected from the server because this violates the lookup settings defined for this table or list. Please reconnect all tables with the server and try again.' The two tables referenced by this query are a native Access table and a linked SharePoint list - I am updating values in SharePoint from values held in the native Access table. I can read the SharePoint list in Access and can read and update the native Access table. I can also update the SharePoint list from SharePoint. I tried to delete the linked table and recreate it but this did not work. Any ideas? Regards RoryRegards Rory

UtterAccess.com is a better Access Specific forum. Other than that, check out these hits and see what applies to your situation: http://www.google.com/search?q=because+this+violates+the+lookup+settings+defined+for+this+tableSteve Clark, MCTS | Twin-Soft.com

I'm having the same problem. I have an MS Access 2010 Database that communicates through a link to a SharePoint 2007 List. On some records (or "items") I'm able to update through my form with no issue. On others (for whatever reason) I'm getting this error: "'You cannot reference rows created when you are disconnected from the server because this violates the lookup settings defined for this table or list. Please reconnect all tables with the server and try again" Since I can update other items, I know that I have a good connection. I'm trying to compare items but I don't see where I've made any data violations. Any ideas?

Access was never designed for the web. So, if I had to quess, I'd go with the fact that there isn't a direct connection and Access suffers separation anxiety. (My dog eats the remote when this happens, so I think you're getting the good end.) Try this: 1. From Access, pull up a record that you know you can, then close it. 2. Unplug the network cable from the NIC card and try to pull up the same record. Do you get the same error?Steve Clark, MCTS | Twin-Soft.com & Easy Bins Dumpster Rentals of Northern VA. (Specializing in driveway-sized roll-off dumpsters.)