Currently I have an Access 2003 application split into two files: 1) A back-end database that contains the data tables and is located on a shared drive. 2) A front-end database that contains forms, queries, reports, macros & modules installed on each users computer. Each form on the front-end has significant VBA code associated with it. The back-end tables are linked to the front-end.

My company wants to make this application available to other divisions located around the world. The suggestion was to put it on the intranet/internet. What would be the easiest way to accomplish this without doing a complete overhaul considering there will be multiple users accessing it simultaneously?

Any insight would be greatly appreciated.