I have a complex set databases on a local server that are all connected to users in the same office (or vice versa). Each user has Access 2000, and their PCs have the application and all the VBA code that's needed to process the information according to the business logic and then write the data back to the server. It works well and I can see no reason to change it, except...

If I want to migrate this out of the office and let each user work from home using Office 365 (or what else?), where does the logical part of the processing occur? Does each user need Office 2010 at home to process the data before sending it back online as a table update? Or does the logic exist in the cloud and the Access module of Office 365 do it all like ASP?

Upgrading to SQL server is not an option - far too late and far too difficult. Sharepoint I don't know - how and where does it handle business logic?

Would a hosted server (for MS Access) and terminal server on the same machine (for access) be a better solution than trying to make this work in the cloud?

All suggestions appreciated.

Hi,

(IMG:style_emoticons/default/welcome2UA.gif)

Not sure if this will help you but I am not familiar with Office 365. I assume that it's just the same as SharePoint though. If so, then you should be able to continue to use the same Access database files you already have (don't think you need to upgrade to 2010, unless you were thinking of letting your users access the data using an Internet Browser). Which means, all the business logic will stay with your files. Office 365 or SharePoint will just become a new location to store the data.

If you do want your users to access the data using an Internet Browser, then you won't be able to use VBA. You will have to upgrade to Access 2010 (your users can use the Runtime version) and convert your VBA codes into macros.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)