world access to a database

[bigmac]

hi all, good news thanks to the help of this forums members i have built a database for my works use and it works fine, now they want me to be able to link it to all our other offices around the world , i am using a front end back end at the moment is it possible to set this up so that all offices can use it, i know that if they can connect to our local drive it works fine , but is there another better way to do this perhaps through cloud ? using access 2013 maybe? any suggestions please.

 

[Pat Hartman]

Your app would need to be completely rewritten to be usable as an Access 2013 web app. Not only will you have to recreate the forms but you will need to convert any VBA to macros. In the process, you would lose any OLE automation features or email capability. You also lose reports as we know them. All you have are web pages which don't print well at all.

In addition, only users defined to your SharePoint site will ever be able to use the app so it cannot be used as an "out-facing" application.

Your best bet is Citrix which is virtually no work on your part and provides excellent performance since the app runs on the Citrix server and only takes keystrokes in and sends pictures back so it has a very small web footprint. Second-best is converting to SQL Server which will probably require some changes to your FE unless you had the foresight to design it with client/server methods in mind. This option could be slower than you would like depending on where the BE is hosted and how that service is configured.