Connecting / Linking to a database on the web
Posted on 2006-06-26
I want to import or link to tables on a MS Access database on a web server.
I have ftp access to that server.
I choose File, Get External Data, Link Tables. I have previously established the ftp location in the folder "ftp locations. I go there & navigate to the Access database on the web server.
When I click link, it says "Not a valid file name". The file name is Calendar.mdb and IS a valid MS Access database.
What am I doing wrong?