Linking Tables over the Internet

[Bill Terrill]

I have a simple question!

I have an ISP where I copy my .mdb which contains only
tables/table data. I have my local copy of Access with
its .mdb file whos tables I would like to link to those
on my Website.

This works on a LAN but not on an FTP site? I've tried
linking (with a mapped ftp site) and a DSN (mapping to
the file on the ftp site).

The first reports the "cannot find file x" where x is the
mdb file name on the ftp site. The second refuses to
connect while setting up the DSN.

I can't use RDO with firewall constraints at my ISP.

This should be very simple!

 

[Joe Fallon]

Not sure where you got the idea it should be simple since it is impossible.
Access cannot connect over ftp.

You will need SQL Server if you plan on connecting over the Internet.