linked table xxx is unavailable. microsoft access cannot contact the server. Check your network connection
I have been using this process for quite some time but for this particular list I am getting issues. My Process What I typically do is: 1.Open a new access “blank” database 2.Click external data then more and select SharePoint list 3.For site address my live data is http://prime.sharepoint.com/teams/gssta/ta/load 4.Link to data source by creating linked data 5.Then I select the list I am working with BP 6.Next I click excel from import and link and select my excel file which is attached (selecting the tab called testdata) I am appending to table BP 7.Next it tries to process and dies off with the error in the title above Matt Pinkston
September 19th, 2011 11:41am

This isn't a programming question so I'm moving it to Admin. 1. Which SharePoint product are you using. 2. What is BP? (Is the name relevant?)SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx Both also have links to extensive book lists and to (free) on-line chapters
Free Windows Admin Tool Kit Click here and download it now
September 19th, 2011 1:05pm

Hi Matt, The scenario may be caused by that the list is corrupted, there is a similar issue that solved by backing up the list and restoring to the site. The copy of the list works well without any issue. You may try to use a copy of the list to see whether it works: go to List Settings->Save List As Templates, make sure to check the Include Content checkbox, create a new list based on the template. Thanks, Qiao Wei
September 21st, 2011 2:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics