Access to Access ODBC connection via Internet?

[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!

[jj]

Nevermind I see you can't even connect via ODBC from Access to Access even
on the same machine or network.

:(
"jj" <[e-mail]> 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!

[Albert D. Kallal]

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