# MS 2013 Access DB via Sharepoint. Resources? **URL:** \ **Category:** In My Humble Opinion\ **Created:** [June 25, 2016, 6:07am UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295 "2016-06-25T06:07:32Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![EmbarrassingDad](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/embarrassingdad/32/5441_2.png) [@EmbarrassingDad](https://boards.straightdope.com/u/EmbarrassingDad)\ **Post date:** [June 25, 2016, 6:07am UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/1 "2016-06-25T06:07:32Z")
I recently directed my company to trust me to build a “dashboard” for our everyday operations… I chose MS Access because it’s a staple of database design, and basically infinitely customizable. Furthermore, the sales people at MS told me I could use Office 2013 (on my desktop) to publish _any_ database to the web for my company to utilize via web browser with Sharepoint. That was entirely false, however, after the trial, I now have many hours into the build. I just bought an 800 page book on the subject, but what is the best resource or forum for Access 2013 Web Apps via Sharepoint? ---
**Author:** ![QuickSilver](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/quicksilver/32/7832_2.png) [@QuickSilver](https://boards.straightdope.com/u/QuickSilver)\ **Post date:** [June 25, 2016, 2:09pm UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/2 "2016-06-25T14:09:48Z")
You need to [publish the Access DB to an SP site](https://sharepoint.rackspace.com/sharepoint-2013-how-to-publish-an-access-database) in order to have integration. There are limits to how deep you can get with this integration primarily because SP lists are not a proper relational dbs. ---
**Author:** ![Me\_Billy](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@Me\_Billy](https://boards.straightdope.com/u/Me_Billy)\ **Post date:** [June 25, 2016, 2:16pm UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/3 "2016-06-25T14:16:39Z")
Stay AWAY from anything Microsoft. Custom programming will NOT WORK on later versions of their products. Everything needs to be reprogrammed! And it seems to me Microsoft could care less! Try an “open source product” like Open Office (or what other people here may recommend)… [https://www.openoffice.org/](https://www.openoffice.org/) ---
**Author:** ![Kalea](https://avatars.discourse-cdn.com/v4/letter/k/b487fb/32.png) [@Kalea](https://boards.straightdope.com/u/Kalea)\ **Post date:** [June 25, 2016, 11:13pm UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/4 "2016-06-25T23:13:12Z")
If you have particular questions, the [MSDN](https://social.msdn.microsoft.com/Forums/en-US/home) and [StackOverflow](http://stackoverflow.com/) forums are great resources. Generally you can Google your question in natural language and find answers there. I believe the MSDN forums require you to have an MSDN membership to post, but anyone can view previous posts. I agree with **Quicksilver** on the limitations of publishing a large-scale relational DB to SharePoint (SP). SP treats tables as lists and relationships as “lookup” fields within a list. You are limited to the number of lookup fields you can have per list. If you have just a few tables, with limited relationships, SP can serve as a good web front end for your database. My CV: I’ve been a SP Admin (2007 through SP Online) for almost 10 years. ---
**Author:** ![Dave\_Hartwick](https://avatars.discourse-cdn.com/v4/letter/d/7feea3/32.png) [@Dave\_Hartwick](https://boards.straightdope.com/u/Dave_Hartwick)\ **Post date:** [June 25, 2016, 11:35pm UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/5 "2016-06-25T23:35:58Z")
Does SharePoint work well with MS Reporting Services in your experience? Or can RS do better without? Talking in terms of interactive web pages, data gathering. ---
**Author:** ![K364](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/k364/32/5_2.png) [@K364](https://boards.straightdope.com/u/K364)\ **Post date:** [June 26, 2016, 12:01am UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/6 "2016-06-26T00:01:32Z")
There is nothing wrong with MS Access for small to medium db’s and concurrent users. But why Sharepoint? Having the data in SP lists will be a relational nightmare and drive you insane. If you implement MS Access, be sure to split Front-End and Back-End. The FE should be copied from a master copy on the network to the User’s C: drives when the User launches the app. Robocopy should be used: it knows when a copy is required (because the master copy FE file is newer than the C: version) I have used this many times and it works well. ---
**Author:** ![Kalea](https://avatars.discourse-cdn.com/v4/letter/k/b487fb/32.png) [@Kalea](https://boards.straightdope.com/u/Kalea)\ **Post date:** [June 27, 2016, 4:06pm UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/7 "2016-06-27T16:06:50Z")
> [@Dave\_Hartwick](#): > > Does SharePoint work well with MS Reporting Services in your experience? Or can RS do better without? Talking in terms of interactive web pages, data gathering. Not terribly well. Microsoft wants to sell you their SP-integrated Business Intelligence modules, which are licensed separately for non-cloud customers, so they don’t have a good API for integrating with RS. I suspect that **dirty1** doesn’t have much of an option about the front-end dashboard location. If they’re using SP for their intranet, the execs likely want a one-stop-shop within the intranet for their dashboard. It’s unfortunate, otherwise RS or **K364** ’s app implementation would be interesting options to explore for front-ending the existing database. ---
**Author:** ![QuickSilver](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/quicksilver/32/7832_2.png) [@QuickSilver](https://boards.straightdope.com/u/QuickSilver)\ **Post date:** [June 27, 2016, 4:20pm UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/8 "2016-06-27T16:20:11Z")
> [@Kalea](#): > > Not terribly well. Microsoft wants to sell you their SP-integrated Business Intelligence modules, which are licensed separately for non-cloud customers, so they don’t have a good API for integrating with RS. > > I suspect that **dirty1** doesn’t have much of an option about the front-end dashboard location. If they’re using SP for their intranet, the execs likely want a one-stop-shop within the intranet for their dashboard. It’s unfortunate, otherwise RS or **K364** ’s app implementation would be interesting options to explore for front-ending the existing database. You know what’s under-valued with respect to senior management dashboards?.. SP Excel Services. Before adding BI to your SP app server, it’s worth exploring building dashboard reports in Excel and exposing them on a SP site using Excel Services, which is already included. ---
**Author:** ![Kalea](https://avatars.discourse-cdn.com/v4/letter/k/b487fb/32.png) [@Kalea](https://boards.straightdope.com/u/Kalea)\ **Post date:** [June 28, 2016, 12:07am UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/9 "2016-06-28T00:07:45Z")
> [@QuickSilver](#): > > You know what’s under-valued with respect to senior management dashboards?.. SP Excel Services. > > Before adding BI to your SP app server, it’s worth exploring building dashboard reports in Excel and exposing them on a SP site using Excel Services, which is already included. Very good point. I wish we had enabled Excel Services in our on-prem environment before migrating to SP Online… everyone in IS leadership is now all gung-ho about Power BI without looking at some of those simpler tools we can enable for general users using tools they already understand like Excel. I don’t know enough about the tool to know if the OP can make use of Excel Services as a front-end for his existing Access DB. It’s definitely a gap in my skill-set that doesn’t look to be filled any time soon. ---
**Author:** ![QuickSilver](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/quicksilver/32/7832_2.png) [@QuickSilver](https://boards.straightdope.com/u/QuickSilver)\ **Post date:** [June 28, 2016, 3:41pm UTC](https://boards.straightdope.com/t/ms-2013-access-db-via-sharepoint-resources/758295/10 "2016-06-28T15:41:45Z")
> [@Kalea](#): > > Very good point. I wish we had enabled Excel Services in our on-prem environment before migrating to SP Online… everyone in IS leadership is now all gung-ho about Power BI without looking at some of those simpler tools we can enable for general users using tools they already understand like Excel. > > I don’t know enough about the tool to know if the OP can make use of Excel Services as a front-end for his existing Access DB. It’s definitely a gap in my skill-set that doesn’t look to be filled any time soon. Some years ago, we piloted BI on an on-prem 2010 farm. Can’t say I was hugely impressed. It was slightly better than the KPI web part solution. I’m sure the more current version 2013/2016/O365 is better. I should look into it. I had another thought, for external databases, perhaps BDC (Business Data Connectivity) would work? But that’s more a reporting solution and involves managed meta-data, not so much a pretty dashboard with graphics solution. Finally, it’s worth checking out what’s available in the O365 (SharePoint) App Store. There are hundreds of various solutions, most of which come with a trial version. Usually they are very inexpensive.