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

Access to Access ODBC connection via Internet?

P: n/a
jj
I have one access database on the desktop and another access database on a
remote web server.

Is there any way to setup an ODBC link between the two? I've tried adding
IP addresses and even domain names to the network path and it never finds
the connection. Is there another way to connect or some other trick to
this?

I'd like the desktop access application to be able to link to and view
tables in the web access database.

Thanks in advance!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
jj
Nevermind I see you can't even connect via ODBC from Access to Access even
on the same machine or network.

:(
"jj" <jj@test.net> wrote in message
news:45******************@twister.rdc-kc.rr.com...
I have one access database on the desktop and another access database on a
remote web server.

Is there any way to setup an ODBC link between the two? I've tried adding
IP addresses and even domain names to the network path and it never finds
the connection. Is there another way to connect or some other trick to
this?

I'd like the desktop access application to be able to link to and view
tables in the web access database.

Thanks in advance!

Nov 12 '05 #2

P: n/a
Well, you can connect to a access database across the net, but you have to
be able to "see" the file in a folder. So, if you use a VPN, and setup a
file share, then in theory you could then browse via network neighbourhood
to the shared folder on the server, and thus actually use the file. So, when
using a JET and a file share, you must be able to "see" the file in a
folder. Using A VPN will allow this.

However, you can't really in a reliably way use a vpn.

For some tips and notes on a using ms-access across the internet, you can
read the following:

http://www.attcanada.net/~kallal.msn/Wan/Wans.html

--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
ka****@msn.com
http://www.attcanada.net/~kallal.msn
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.