Can ADO connect to a remote mdb on a web server?

[bcanavan]

I'd like to connect to an mdb(v2002+) on the web server which contains
readOnly linked tables. My remote users are not permitted to connect
directly to the sql server db that the mdb links to because sql server
is outside the dmz.

The remote users have either Access 2002 or 2003 installed.

Any other suggestions for connecting would be appreciated.

Thanks,

Bob

[David W. Fenton]

bc******@bmghomes.com wrote in
news:11*********************@g47g2000cwa.googlegro ups.com:

I'd like to connect to an mdb(v2002+) on the web server which
contains readOnly linked tables. My remote users are not
permitted to connect directly to the sql server db that the mdb
links to because sql server is outside the dmz.

The remote users have either Access 2002 or 2003 installed.

Any other suggestions for connecting would be appreciated.

The only solution if your sysadmins won't open a port to let people
into the SQL Server (which is a perfectly sound decision on their
part) is to allow the remote users to connect via VPN, which would
then put them inside the firewall, and able to connect to the SQL
Server.

That's the usual way of handling these things. I certainly wouldn't
want a SQL Server port open to the wild-and-woolly Internet.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[bcanavan]

Thanks, David.

I've explored both options you mention, and for one reason or another
they won't fly here. Or at least, a single solution using either
option can't be applied to all my users. I'm looking for a secure
least-common-denominator, with the hopes of one day eliminating Access
from the client pc's altogether. It's only function at the moment is
local report generation.

I'm looking at xml datasources now. Having some success.

Thanks again.

Bob

[David W. Fenton]

bc******@bmghomes.com wrote in
news:11**********************@f14g2000cwb.googlegr oups.com:

I've explored both options you mention, and for one reason or
another they won't fly here. Or at least, a single solution using
either option can't be applied to all my users. I'm looking for a
secure least-common-denominator, with the hopes of one day
eliminating Access from the client pc's altogether. It's only
function at the moment is local report generation.

Well, ASP to produce HTML should be able to produce decent reports,
not as good as Access reports, but not terrible, either.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc