By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,065 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,065 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.