data.mdb on external web server

[TADropik]

I'm trying to access data that resides in a .mdb that resides on an external
web server. I have the IP address and file name.

Something like http://123.45.67.8/folder/data.mdb

I have an Access 2003 application that I am running on my local and would
like to link to the external database or transfer the the data in to my
database automatically.

What are some ways to accomplish this?

 

[Albert D. Kallal]

You can't link to a mdb file via "http". You have use what is called windows
networking

You also can't link to a mdb file via ftp either. You have to use the
correct protocol.

In your case, what you need to do is setup a what is called a VPN. A Virtual
Private Network is a system that lets you "extend" windows networking OVER
the internet. You be able to browse all the fields in the "folder" via
network neighborhood. So, to LINK to a back end on another machine OVER the
internet, you must EXTEND windows networking OVER the internet (http, or ftp
is NOT windows networking).

However, before you go to all the trouble to extend windows networking (vpn)
over the internet, you need to read the following article of mine on why
this generally can't work well.

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html