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.
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.
MS Access 2007- Migration : Need suggestions
