Hello Everyone,
We have an Access Application built on Access 2007.
This is built in Split Data Architecture, The backend sits on the shared drive and the front-end is on Users Machine.
As a matter of security our organization has decided to move the back-end data to SQL SERVER or ORACLE.
Also the new Office 365 is going to come around in few months.
Plan is to keep the front-end still in Access and move the back-end to some other platform.
Questions:
Moving Back-end to Oracle is technically good option? as the enterprise standard is Oracle platform in our organization.
Once the back-end is moved, How does Office 365 will have impact on our application (the front-end)
What are the steps involved to upgrade to new office 365,
for example, the Application is already on users machine which Access 2007, in a week the organization is uninstalling the Office 2007 and installing Office 365.
When the user opens the App on Office 365, will it work?
As a developer do we need to do any pre-work on this?
Today, the application is working perfectly with around 100 users.
Please let me know your experiences and valuable thoughts, as this is going to be a challenging task for me.
Any help or information is highly appreciated.