Forum Discussion
Leavving Access for Sharepoint
I currently manage with client data in MS Access. I am considering Sharepoint and Power Apps to replace Access. Here is what I want to accomplish: 1. Client portal/exposure to their data. The ab...
Thanks you so much for your detailed and thoughtful answer. My practice is a volume practice - so at any one time I have 60-80 clients. That would be a very expensive then for each one to have a spoke SharePoint website wouldn't it?
That's why I mentioned it so prominently, yes. Potentially, 60*5 or $300 a month just to have a way for clients to check in on their own data. Plus you would have to manage security so that each one sees only their own data. Doable, but not the default approach.
There is an option called Power Pages, which supposedly is aimed at external users, but I know little about it and I have no idea if it would support what you need. Check it out as well.
I'm torn here. I think Power Apps is a great tool. I see it as a way to free some functions--such as the inventory stock take--from the desktop without abandoning the strength of the desktop database application. It's just not the most appropriate approach here, I don't think.
Do take a look, though, at the last few videos I put up on YouTube to get an idea of how you MIGHT incorporate something like this into a larger system. There's a series on Mike's Mobile Library, which does cover the range of functions duplicated from the desktop, as well. You probably don't have time to watch them all in their entirety, but they can give you a taste of what you could accomplish.
There is an option called Power Pages, which supposedly is aimed at external users, but I know little about it and I have no idea if it would support what you need. Check it out as well.
I'm torn here. I think Power Apps is a great tool. I see it as a way to free some functions--such as the inventory stock take--from the desktop without abandoning the strength of the desktop database application. It's just not the most appropriate approach here, I don't think.
Do take a look, though, at the last few videos I put up on YouTube to get an idea of how you MIGHT incorporate something like this into a larger system. There's a series on Mike's Mobile Library, which does cover the range of functions duplicated from the desktop, as well. You probably don't have time to watch them all in their entirety, but they can give you a taste of what you could accomplish.
Another option may be to use Blazor rather than PowerApps. I chaired an Access Europe meeting about this last Wed and the video will be on YouTube soon. See https//isladogs.co.uk/aeu-18/
I believe there is also a similar item on the Denver Area Access User Group channel.
The licensing costs are likely to be significantly less.
