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
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
ASKER
all users same error, net connections are fine
Again, ...
"Anything special about this list?"
...as this seems to be the only variable here...
"Anything special about this list?"
...as this seems to be the only variable here...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Anything special about this list?
Is this same issue for all users, or just you?