link tabels in get external data

[Guest]

I use ftp to access to foder of DB in my host
the link dilog box show it (data.mdb) but canot open it
in the end it show a msgbox (NOT A VALID FILE NAME)
but data.mdb is valid becuase I make It And open it several time to my hard.
but now I want open it in my HOST(FTP).
What can I DO?

My file may be BIG(100MB) in fiuture and I want make a link and make a quary
for opening a part of it.
file>GEt external data>link tabels
is this way right?
Thanks

 

[John Vinson]

I use ftp to access to foder of DB in my host
the link dilog box show it (data.mdb) but canot open it
in the end it show a msgbox (NOT A VALID FILE NAME)
but data.mdb is valid becuase I make It And open it several time to my hard.
but now I want open it in my HOST(FTP).
What can I DO?

My file may be BIG(100MB) in fiuture and I want make a link and make a quary
for opening a part of it.
file>GEt external data>link tabels
is this way right?
Thanks

NO, it is not.

You cannot link from Access to an FTP folder. You must transfer the
file to your local area network and connect to it from there.

John W. Vinson[MVP]