Jason Medero SharePoint MVP: SharePoint Space for all things SharePoint, OCS, RMS, InfoPath, and Office

I ran into this little issue and wanted to record it on my blog in case others experience the same error that I had run into today.  So today I was using Access 2007 with a MOSS 2007 site to export a decent size list (1500+ items).  The normal process that I was going through would be to first import the SharePoint list into Access 2007.  There is a good article which states how to accomplish this here: 

http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?List=8d9e2a99%2Df288%2D47c2%2D916b%2D2f32864f7b82&ID=68&RootFolder=%2A

I would then make some mass changes, add some items to the list and then export back to SharePoint but create a whole other list in the process.  The process for this was to simply right click the linked table (The SharePoint list) that I had originally exported from SharePoint.  Then click on export as the screenshot below describes.

Once I selected a SharePoint list another dialogue box would pop up for me to enter the URL of the SharePoint site.  Or select from an address that I have used previously.  I proceeded to enter the IP address of the server (simply because I couldn't remember what the server name was but somehow remembered the IP of the server.  So I punched in 172.16.1.100 and specified a name for my new list that was to be created at the URL that I specified above.  I checked the box to open the list when the process was finished so I could check to make sure everything was going to be ok after the creation.  I clicked ok and for some reason I got the error shown below "Microsoft Office Access could not connect to the site you specified.  Verify the address of the site or contact your administrator"…..hmmm I quickly found the servername that I was using and dropped that in.  It worked and created the new list at the specified URL above and exported all of the items perfectly!

Lesson is use the servername if you can.  I have also tested using a friendly name (Host header URL) and as long as their is an entry in the Hosts file or an A record created in DNS I did not have any problems.  Hope this tips helps!

Cheers,

This entry was posted on Monday, March 16th, 2009 at 11:40 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

I ran into this little issue and wanted to record it on my blog in case others experience the same error that I had run into today.  So today I was using Access 2007 with a MOSS 2007 site to export a decent size list (1500+ items).  The normal process that I was going through would be to first import the SharePoint list into Access 2007.  There is a good article which states how to accomplish this here: 

http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?List=8d9e2a99%2Df288%2D47c2%2D916b%2D2f32864f7b82&ID=68&RootFolder=%2A

I would then make some mass changes, add some items to the list and then export back to SharePoint but create a whole other list in the process.  The process for this was to simply right click the linked table (The SharePoint list) that I had originally exported from SharePoint.  Then click on export as the screenshot below describes.

Once I selected a SharePoint list another dialogue box would pop up for me to enter the URL of the SharePoint site.  Or select from an address that I have used previously.  I proceeded to enter the IP address of the server (simply because I couldn't remember what the server name was but somehow remembered the IP of the server.  So I punched in 172.16.1.100 and specified a name for my new list that was to be created at the URL that I specified above.  I checked the box to open the list when the process was finished so I could check to make sure everything was going to be ok after the creation.  I clicked ok and for some reason I got the error shown below "Microsoft Office Access could not connect to the site you specified.  Verify the address of the site or contact your administrator"…..hmmm I quickly found the servername that I was using and dropped that in.  It worked and created the new list at the specified URL above and exported all of the items perfectly!

Lesson is use the servername if you can.  I have also tested using a friendly name (Host header URL) and as long as their is an entry in the Hosts file or an A record created in DNS I did not have any problems.  Hope this tips helps!

Cheers,

This entry was posted on Monday, March 16th, 2009 at 11:40 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.