Link tables on between 2 db's on FTP site Ken_g 12.07.2006 17:47:01 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?

Re: Link tables on between 2 db's on FTP site "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 12.07.2006 21:23:07 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Ken_g" <Ken_g[ at ]discussions.microsoft.com> wrote in message news:04BED3C7-69B7-4123-A6E2-C3DC9A4A3EB7[ at ]microsoft.com... [Quoted Text] >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?

Re: Link tables on between 2 db's on FTP site Ken_g 12.07.2006 22:01:02 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 on the ftp site), but the link manager won't let me do it. Say's it's an invalid file. "Douglas J. Steele" wrote: [Quoted Text] > 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. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Ken_g" <Ken_g[ at ]discussions.microsoft.com> wrote in message > news:04BED3C7-69B7-4123-A6E2-C3DC9A4A3EB7[ at ]microsoft.com... > >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? > > >

Re: Link tables on between 2 db's on FTP site "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 12.07.2006 23:14:07 How did you specify the directory on the ftp site? You must use the actual location on the server, not an ftp:// address. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Ken_g" <Keng[ at ]discussions.microsoft.com> wrote in message news:58F95A81-CAEF-461C-96D9-47A8BE36F077[ at ]microsoft.com... [Quoted Text] >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 > on the ftp site), but the link manager won't let me do it. Say's it's an > invalid file. > > > > "Douglas J. Steele" wrote: > >> 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. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "Ken_g" <Ken_g[ at ]discussions.microsoft.com> wrote in message >> news:04BED3C7-69B7-4123-A6E2-C3DC9A4A3EB7[ at ]microsoft.com... >> >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? >> >> >>

Re: Link tables on between 2 db's on FTP site Ken_g 12.07.2006 23:40:02 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" wrote: [Quoted Text] > How did you specify the directory on the ftp site? You must use the actual > location on the server, not an ftp:// address. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Ken_g" <Keng[ at ]discussions.microsoft.com> wrote in message > news:58F95A81-CAEF-461C-96D9-47A8BE36F077[ at ]microsoft.com... > >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 > > on the ftp site), but the link manager won't let me do it. Say's it's an > > invalid file. > > > > > > > > "Douglas J. Steele" wrote: > > > >> 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. > >> > >> -- > >> Doug Steele, Microsoft Access MVP > >> http://I.Am/DougSteele > >> (no private e-mails, please) > >> > >> > >> "Ken_g" <Ken_g[ at ]discussions.microsoft.com> wrote in message > >> news:04BED3C7-69B7-4123-A6E2-C3DC9A4A3EB7[ at ]microsoft.com... > >> >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? > >> > >> > >> > > >

Re: Link tables on between 2 db's on FTP site "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 13.07.2006 01:00:41 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. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Ken_g" <Keng[ at ]discussions.microsoft.com> wrote in message news:4D1FEFFA-CD66-4923-B876-B61BEE4E33D2[ at ]microsoft.com... [Quoted Text] >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" wrote: > >> How did you specify the directory on the ftp site? You must use the >> actual >> location on the server, not an ftp:// address. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "Ken_g" <Keng[ at ]discussions.microsoft.com> wrote in message >> news:58F95A81-CAEF-461C-96D9-47A8BE36F077[ at ]microsoft.com... >> >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 >> > on the ftp site), but the link manager won't let me do it. Say's it's >> > an >> > invalid file. >> > >> > >> > >> > "Douglas J. Steele" wrote: >> > >> >> 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. >> >> >> >> -- >> >> Doug Steele, Microsoft Access MVP >> >> http://I.Am/DougSteele >> >> (no private e-mails, please) >> >> >> >> >> >> "Ken_g" <Ken_g[ at ]discussions.microsoft.com> wrote in message >> >> news:04BED3C7-69B7-4123-A6E2-C3DC9A4A3EB7[ at ]microsoft.com... >> >> >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? >> >> >> >> >> >> >> >> >>