By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,099 Members | 763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,099 IT Pros & Developers. It's quick & easy.

Access 2010 link to Sharepoint 2010 problem

P: 11
I have a table in Sharepoint 2010 that users have submitted proposals into. I have a link to it in my Access 2010 database. The link works perfectly on my XP laptop but not on my Windows 7 desktop. I've set the trusted location. I have the current Windows ServicePack. Also, it looks as though I can connect to an internal Sharepoint site "http://sharepoint..." but the problem is occuring on the sharepoint site that can be accessed by external partners "http://connect... The error reads "Microsoft Access could not connect to the site you specified. Verify the address of the site or contact your site administrator." Again, this works fine on my XP.

Does anyone have any ideas on why this would be?

I'm attaching a screenshot.

[imgnothumb]http://bytes.com/attachments/attachment/6756d1354821957/access_link_sp_error.jpg[/imgnothumb]
Attached Images
File Type: jpg access_link_sp_error.jpg (41.8 KB, 3553 views)
Dec 6 '12 #1
Share this Question
Share on Google+
11 Replies

zmbd
Expert Mod 5K+
P: 5,397
Jo Ann Dullum:
It is always preferable to place the error message as text within your posts. You'll get a greater number of replies. In fact the attachment hadn't have been available via Bytes I would not have seen it!

As it is, I can't read what is in the picture (maybe the contacts are dry again :-) ) thus I'm unable to help you.

You may need to get your IT department involved in that they may not have (re)authorized you to the sharepoint for that terminal... also double check the path, seriously, happens more than you would imagine. :)

Next thing, is the database from another version of Access (like 2003?) somtimes the versions do not translate well and can cause issue. You may need to Open a new blank database and then import the old stuff into the new shell.
Dec 6 '12 #2

P: 11
I did type the error message in my post but I guess I should have highlighted it. I created the database in Access 2010 have tried linking from a new database but I still get the same error.

I think I will talk to IT but I can already hear them saying it is an Access problem.

Thank you for your response though.

@zmbd
Dec 6 '12 #3

NeoPa
Expert Mod 15k+
P: 31,770
Fair point Jo Ann. I've just highlighted that in your post to make it easier to see. You did a good job including it, but some might be surprised to see it so far into the post. No criticism, just explaining how people read things sometimes ;-)

When speaking to IT, I suggest you prepare details of exactly how you are attempting the connection. Address; credentials; etc. With this to hand they will either be able to explain what you're doing wrong (which is still possible even if it works in other situations), or they can take responsibility for the problem. They should not be able to say it's simply an Access issue.

Best of luck.

PS. In the mean time, Z is still willing to work with you on this, so I suggest an early response to his questions would be profitable. He's very clever and knowledgeable in this whole area, I can assure you.
Dec 6 '12 #4

zmbd
Expert Mod 5K+
P: 5,397
There is a number associated with that error message as the text is associated with two different errors: 31559 and 31577 - Microsoft Access 2010 Error Numbers and Descriptions
Dec 7 '12 #5

P: 11
No answer yet for this problem. I have our IT working on it and a person knowlegable in Sharepoint. He has been able to replicate my error:

Here is his response: "If I open Access and try to import external data from that site, I get the same error that you do.If I open Internet Explorer, log into that site, then open Access and try to connect, it works! I tested and confirmed this behavior both on a Windows 7 machine with Office 2010 and Windows 8 with Office 2013."

I have followed his procedure and it still does not work. Just thought I'd provide an update...
Jan 16 '13 #6

NeoPa
Expert Mod 15k+
P: 31,770
Jo Ann, I suggest you need to read and respond to Z's question in post #5.

He would reasonably have assumed you were no longer interested in the thread.
Jan 16 '13 #7

P: 11
@NeoPa
Sorry, didn't mean to ignore I will reply now.

@zmbd
zmbd - Did not mean to ignore. I did follow your links but the errors 31559 and 31577 say the same thing: "Microsoft Access could not connect to the site you specified. Verify the address of the site or contact your site administrator."

I continued following up with our IT as was suggested.
Jan 16 '13 #8

zmbd
Expert Mod 5K+
P: 5,397
@Jo Ann Dullum
Yes, I know the text is the same - that is why I asked specifically for the number. The possible solutions are very different; however, if you do not need/want my help then please let me know... and in anycase, you will need your IT security's involvement for the solution.
Jan 16 '13 #9

NeoPa
Expert Mod 15k+
P: 31,770
Jo Ann, I see that your responses are more down to a certain level of confusion than any deliberate intention to ignore. Let me clarify if I can, so that you appreciate that Z actually wants to know which number is shown, as he believes he may be in a position to help you further with this issue if/when armed with that information.

Clearly you noticed that both different errors have the same message associated. However, the different was emphasized for good reason. Only with the number can anyone determine which of the two errors you're struggling with. Of course, it may well be that your IT guys manage to find a way to help you, but it can't hurt to have Z continue to assist. Z may find something your people don't know about.

To help though, Z needs you to post the error number associated with the error.
Jan 17 '13 #10

P: 11
@zmbd
zmbd
There is no number associated with the error that I can find.
Jan 22 '13 #11

zmbd
Expert Mod 5K+
P: 5,397
Error 31559: More than likely due to a malformed DoCmd.TransferSharePointList

Error 31577: More than likely due to a corrrupted database file structure.

Both errors can also be caused by the user not having correct permissions to the sharepoint workspace - read but not modify and so forth. Both errors also have other non-related causes. Without the number I'm afraid there is nothing more I can do to help.

I've just noted that your posted picture has a blured out region in the title, what if anything was there?
Jan 22 '13 #12

Post your reply

Sign in to post your reply or Sign up for a free account.