link tabels in get external data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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]
 
Back
Top