Access 2010 link to Sharepoint 2010 problem

[Jo Ann Dullum]

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.

[zmbd]

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.

[Jo Ann Dullum]

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

[NeoPa]

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.

[zmbd]

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

[Jo Ann Dullum]

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...

[NeoPa]

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.

[Jo Ann Dullum]

@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.

[zmbd]

@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.

[NeoPa]

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.

[Jo Ann Dullum]

@zmbd
zmbd
There is no number associated with the error that I can find.

[zmbd]

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?