For whatever reason, Access does not behave like other Office (or
other) documents. We worked with Microsoft even on this one and
found that they have to download a local copy of the file, use it,
and then upload it back. Not desired, of course....but.....
On the flip side, another coworker of mine did some really awesome
stuff exporting lists to Access and joining them to other data
sources (i.e., exported surveys, joined the submitter names to our
central warehouse data etc...). Or...if their database isn't
an "app", might be worth exploring if any of it could be converted
into SharePoint lists. Of course, if they are related tables or a
more complex "app", that may not be desirable.