Access and SharePoint: a look at integration points from 2003 to 2010

re: Access and SharePoint: a look at integration points from 2003 to 2010

Steven Thomas — Tue, 23 Aug 2011 01:38:48 GMT

Thanks, Josh, for your comment.

I don't have any information about why in-browser Access Services Reports are not currently supported by Office 365, nor whether or when they will be. As I've said on this blog in other threads, there are currently no plans to add that functionality, but Microsoft is considering whether to do so.

The folks in charge of those decisions will make the information available on the Office 365 forums as soon as it is feasible. Although I may post about it on this blog if the decision is made to add that support, such information would show up on those forums before it shows up here.

Thanks again for your interest!

-Steven

re: Access and SharePoint: a look at integration points from 2003 to 2010

jbooker — Mon, 22 Aug 2011 00:12:20 GMT

Steven,

Can you provide any info as to why Access Services Reports are not available in Office365? When will they be? There are lots of folks asking in O365 forums and all we hear are crickets chirping.

TIA,

Josh

re: Access and SharePoint: a look at integration points from 2003 to 2010

Frank Daske — Wed, 10 Aug 2011 09:51:13 GMT

Acess Services is one idea only to share Access data in the cloud. What about this one?

www.layer2.de/.../Cloud-Connector-for-SharePoint-2010-Office365.aspx

It will not only work for Accesss but for almost any on-premise data, to share it in the Microsoft Office 365 cloud using native list replication in SharePoint Online.

re: Access and SharePoint: a look at integration points from 2003 to 2010

Steven Thomas — Fri, 05 Aug 2011 18:26:33 GMT

Martin, thank you for your question - it's a great one.

Currently, you can't connect Access Services sites to other SharePoint sites by linking to lists. Ben's workaround is an interesting scenario, and hopefully it provides the solution you need. I don't have any information about whether this functionality will be available in future versions, but I will definitely pass along your feedback to the relevant folks here at Microsoft.

And thanks Ben, for the original material and for jumping in with a workaround suggestion! :)

--Steven

re: Access and SharePoint: a look at integration points from 2003 to 2010

Ben Clothier — Fri, 05 Aug 2011 13:43:30 GMT

Hi, Martin -

It sounds like you want to use SharePoint lists that exists somewhere else on the SharePoint farm? If that is the case, then the thing is that a web database can only use only SharePoint lists within that specific site you published the web database to. So if the list lives on http://server/site1/ and your web database is on http://server/site2/ then your web database cannot use the list from site1 as a web table, though you can certainly link to the SharePoint List in the client.

A possible workaround for this situation is to take advantage of the new Web Browser control and set it to point to the site1. You may also want to define a Data View page to present your list in a nice layout and use that page. That way you get to have all data on one screen. (I doubt you can place the web browser control inside the web report but that's just off the top of my head but it shouldn't stop you from placing a web browser on the same web form where you're also embedding your web report for online viewing).

Is that something you were looking for?

Ben

re: Access and SharePoint: a look at integration points from 2003 to 2010

Martin Hatch — Fri, 05 Aug 2011 11:01:57 GMT

Steven

I am desperately looking for a solution for displaying reports based on related SharePoint lists through the web.

I have found Access "linked SharePoint lists" to be awesome, and I can use that to create Queries and Reports no problem. The Access Services publishing is also VERY impressive and I was slightly blown away when I started playing around with it.

However whenever I pull in multiple related *EXISTING* SharePoint lists to create reports I try to publish these to the web and get "web compatibility errors". I don't really want to go down the more "hardcore" SQL Reporting Services route (and I've read that doesn't even support list relationships through lookup columns).

So is this a current limitation with Access 2010 and SharePoint Access Services?

If so, any idea when this will be "added" as a feature?

thanks

Martin Hatch