Access app that creates Excel / PDF documents (1 Viewer)

We have a desktop Access 2007 app that's split into front-end / back-end components. As well as updating the back-end data, the app creates Excel & PDF documents in a number of sub-folders which exist in the same folder as the back-end.

It's quite a complicated data structure and the app has lots of VBA code but it has all worked beautifully for a number of years, going through several upgrades. The front-end and back-end have both been on just one PC so no multi-user access required.

Now the user wants to be able to use the full app from any worldwide location but his UK-based assistant must be able to use it fully at the same time; both of their PCs have Office 2010 installed including Access. It seems like the simplest way to do it is to move the back-end component as-is to "somewhere" on the web along with all the Excel and PDF documents in their sub-folders, and then to put the front-end onto both PCs linked to the web-located back-end. We'd like to use a Sharepoint document folder as that "somewhere", so two questions:

1) Will it work?
2) How will we find the web address (?) of the Sharepoint folder to link to?

(We have already looked around for an answer before typing all this out, believe me! And we're pushed for time so we really really don't want to convert to proper Sharepoint lists or make any massive code changes unless there's no alternative.)

I would say the simplest approach would be remote desktop access. Doesn't involve Sharepoint and is fairly simple to set up.

If you mean controlling the UK PC from abroad then, yes, great minds think alike (!) but the user didn't like that solution (*) when we suggested it to him and he's the one in charge so we had to keep looking.

* His issue was that he wouldn't be able to remotely use the UK PC while his assistant was on it, even though the chances of that happening are very close to zero!

(Is it hot down your way? It's stifling up here in Tring. I may need a cooling beer or two soon.)

Set up a remote app on a Terminal server login for him, his assistant should be running a separate local network version.
And yes it did get very warm! Cold beers whilst watching some T20 cricket went down a treat