SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm setting up an Access 2010 database to have a table that is linked to a Sharepoint list, and I'm experiencing connectivity problems.

Whenever I edit a record in the linked table, and then press down to complete the edit, Access always loses connectivity to Sharepoint, and then when I reconnect, I get a warning saying that there are conflicts between my changes and the ones that I made several minutes ago, even for fields that I didn't change on this edit.

In addition, Access seems to intermittently disconnect from Sharepoint at random, requiring me to keep a constant eye on the bottom-right corner of the screen so I can restore the connection and synchronize.

This is not happening for all the sites on the Sharepoint server; I was able to connect and stay connected to a sandbox site that I created. The list I'm trying to connect to has 41 fields; I'm wondering if the size might be an issue for connection stability.

share|improve this question
Are you connecting to a SP 2010 site? – Ryan Erickson Mar 19 '13 at 23:45
@RyanErickson, no, it's SP 2007. – sigil Mar 20 '13 at 0:35
It may be an issue with the office and sharepoint versions not matching up. Are you able to try this with Access 2007? – Ryan Erickson Mar 20 '13 at 19:02
@RyanErickson: no, all the machines here are Access 2010. I don't think it's a version mismatch issue, because the sandbox site that I successfully connected to is also on a SP2007 server in the same intranet. – sigil Mar 20 '13 at 21:00
I ended up just connecting to the site via Sharepoint Web Services (in C# .NET and VBA), instead of using Access. It needs a lot more coding, especially for building CAML queries and parsing the XML results, but it's more reliable. – sigil Oct 9 '13 at 17:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.