Sharepoint Or Office 365, Access 2016
Jan 18 2017, 04:11 AM
Joined: 7-April 08
Not too sure this is the right forum but here goes.
I am working for a small business that is running office 365 and I have provided a number of Access databases for them which are all split in that they all have a front and back end. Is there any way I can use office 365 or Onedrive to put the backend database in a shared place so that I can create a multi-user environment?
Jan 18 2017, 08:30 AM
Joined: 20-June 02
From: Newcastle, WA
I would advise against it, if your intention is to put the BE in one of locations and link the FEs to them from your users' desktops. Even less desirable, IMO, would be putting both the FE and BE on SharePoint for people to run from there.
Apr 17 2017, 10:00 AM
Joined: 4-August 14
I have a couple of clients who are now using Office 365 with local front-ends and the back-end data uploaded into Sharepoint lists. No problems since setting up - approx 6 months now for the first system. Very flexible for the first client - the need was because they were moving premises and would have had a few weeks without a network or server. Office 365 with Sharepoint lists meant they could operate as normal with just an internet link. Second client is also finding it a good solution. Neither client uses more than a few thousand rows in their main tables. Operating speed is fine. A bit slower to get going while the internet link is established (I'm talking a few seconds here) but in operation it is indistinguishable from networked back-end. A beneficial side effect is they no longer need to worry about backing-up their data ... I am a bit nervous about this but Microsoft are supposed to have good redundancy. I have considered setting up a local backup routine but I'm not convinced it is worthwhile.
|Search Top Lo-Fi||27th April 2017 - 02:02 AM|