Link tables on between 2 db's on FTP site

[Guest]

I have two Access databases on the same FTP site. I need to link 2 tables
from one db into the other database. Can this be done? How?

 

[Douglas J. Steele]

Not quite sure what that would accomplish for you.

It's not as though you can run the application on the FTP site. If you use
FTP to download the two databases, you'd need to relink them to point to the
new location.

 

[Guest]

I have a web page that pulls data from the tables in a database. I want to
change the page to pull some additional data which is contained in differnet
database. Instead of setting up a new connection to the other database, I was
thinking by linking the tables I could pull the info from one database
instead of two.

I tried linking the tables to the point of the new connection (the directory

 

[Douglas J. Steele]

How did you specify the directory on the ftp site? You must use the actual
location on the server, not an ftp:// address.

 

[Guest]

I used the ftp:// address because Link Manager in Access will only let me
"browse" to a location to change the link. Is there a way to change the link
location manually instead of using the Link Manager "browse" button?

 

[Douglas J. Steele]

You can set it manually (see http://www.mvps.org/access/tables/tbl0009.htm
at "The Access Web" for one approach), or (I think) you can type the full
path to the file where it asks for the filename. You should be able to find
it through the Browse option as well, though. Go through Network
Neighborhood if you have to.

Bottom line is that Access recognizes neither the FTP nor HTTP protocols.