Home / server / Questions / 761290
In Process
kankamuso
Asked: 2016-03-04 04:32:26 +0800 CST

Office 365 and Access doubts

  • 772

We are planning to move from an on-premises solution to a hosted one for our office applications. Office 365 includes Access for some of its Enterprise plans (namely, E3 and E5 I think). As we are currently using Access, some doubts about migration, compatibility and needed products arise:

  • Are there still restrictions (like it used to be with VBA) for the migration of Access to cloud solutions?.
  • Which products do I need to purchase separately in order to be able to share an Access database among all the colleagues? (I have read about Access Services, but I don't know if this implies I also need Sharepoint, if sharepoint is included with Office 365 nowadays... I cannot come to a conclusion).

Hope someone cane shed some light on this as I am always afraid of Windows ecosystem limitations and extra, unexpected costs and incompatibilities...

Thanks in advance,

Jose.

microsoft-office-365

1 Answers

  1. Access online is a service in SharePoint. It will allow you to create an application in Access and upload it - but it's not really Access. It takes the Access DB and converts it to SQL, SharePoint then becomes a front end to it. There is no one that tell you if that will work or not unless they have your actual Access Solutions.

    That being said if you have an E3 license - this is a suite of products that include the Office Pro Plus SKU. So you can continue to use Access from the desktop applications. E3 includes access to Exchange, SharePoint, and Lync which are all hosted with Microsoft. You can spin up a trial and test importing your existing Access DB's into Access services and see if that will meet your needs.

    With Remote App - you don't have to license Office 365 (but you still can and take advantage of both). If you have your own applications you can install them on your image and use them from there. It's Remote Desktop Services (RDS) hosted again by Microsoft so you don't have to manage those servers. Just be sure to check your license agreements. Nearly every MS product requires you have active Software Assurance to deploy it to a hosted service.

    • 0