Apr 21 2020 07:18 AM
Hi, how does online version of access works? For now I am only working in the desktop application, but I see a challenge when I need to share the data with more people in the organization.
I am also considering collecting some data from my database into a PowerBI Report, is that working okay?
Apr 21 2020 09:56 AM
Solution@Cleo Otterbech There is currently no "online" version of MS Access. Three prior attempts to implement that have proven inadequate and were deprecated.
You can share the data with other users in your organization, though, in a few different ways.
You will need to start by splitting the data from the interface objects, just like you would with an online database.
Another option, if you must share the relational database application with users outside your network, is to place the tables in a remote SQL Server or SQL Azure database, i.e. a "cloud" location to which all users can link. If you go this route, of course, the Front End accdb links to that cloud database and each user gets their own, individual copy of that Front End.
There are other options, but we'd need more information on your business environment to know if they would be appropriate.
Apr 22 2020 01:12 AM
Thanks @George Hepworth , today we are sharing via our internal network/folders and only internal users, not externals. The way it is today I would be happy to be able to share at list the reports, I was thinking Power BI could be a solution.
Apr 22 2020 06:26 AM
@Cleo Otterbech For reporting, Power BI is a great choice, IMO. Of course, that implies you have a site where the PBI files can be published, e.g. an O365 site.
Nov 26 2020 03:29 AM
@George Hepworth Hi again,
I have build my Access database with tables and linked tables from SharePoint. An I am also using this data to build a PowerBI Report to share the data with the organization.
We are sharing the application on a internal shared location, but what I see now is that when one open the database it is locked by the user even know none table is being used. Does this has something to do with the linked tables from SharePoint sites?
Nov 26 2020 07:02 AM
I'm not quite sure how you are sharing the relational database application, but if you mean that you have ONE copy of the Access accdb, and everyone is trying to use that same accdb, then that is the problem.
Each user MUST have their own copy of the Access accdb, all of which are linked to the tables, or in this case, the SharePoint lists.
Each user's accdb, which we call a "Front End" or FE, should be on their own computer, not in a shared location.
That "split database" protocol is the only safe way to share a relational database application among two or more users.
The problem won't be related to using SharePoint lists, though.
Apr 21 2020 09:56 AM
Solution@Cleo Otterbech There is currently no "online" version of MS Access. Three prior attempts to implement that have proven inadequate and were deprecated.
You can share the data with other users in your organization, though, in a few different ways.
You will need to start by splitting the data from the interface objects, just like you would with an online database.
Another option, if you must share the relational database application with users outside your network, is to place the tables in a remote SQL Server or SQL Azure database, i.e. a "cloud" location to which all users can link. If you go this route, of course, the Front End accdb links to that cloud database and each user gets their own, individual copy of that Front End.
There are other options, but we'd need more information on your business environment to know if they would be appropriate.