Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

linked table xxx is unavailable. microsoft access cannot contact the server. Check your network connectionr

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
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

...and have you checked your network connections?

Anything special about this list?

Is this same issue for all users, or just you?
Avatar of Matt Pinkston
Matt Pinkston

ASKER

all users same error, net connections are fine
Again, ...
"Anything special about this list?"
...as this seems to be the only variable here...
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial