Jim,
Later versions of Windows--2k, XP & so on, do a better job of presenting the
contents of folders on a web server in standard Explorer window. Pretty
much if Windows can connect to it, Access can too. Also, ODBC or its
current equivilant, is rather good at presenting to Access data as tables
from lots of formats & locations. So, short answer--it isn't hard to do
what you want.
There are issues around Jet's ability to support a limited number of
concurrent connections to an .mdb that have been discussed here previously.
The argument boils down to capacity--if your transaction volume is low
enough Jet will do fine. If you anticipate exceeding roughly a dozen or so
concurrent connections then it may be worth investigating a different rdbms
server engine.
"Jim" <go****@whatifcomputers.com> wrote in message
news:39**************************@posting.google.c om...
Is there a way to access a mdb file remotly via MS access?
I have a application that I'll need to us access for reporting.
and local updating
I'd like to keep the mdb file (data file) on a server hosted by
another company so that I can use asp for the web site hosted there.
Is there a way to connect to the mdb file just like you might a SQL
server?
Jim