Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

How to connect to MS Access Database via FTP

Hi guys,

If I have a MS Access database in my local computer, my connection will be something as follows :

ODBC CONNECT TO [MS Access Database;DBQ=C:\myFolder\myDatabase.accdb];

If I have a file in a ftp file, my connection will be something as follows :

[ftp://user:password@ftp.mysite.com/myFolder/myFile.txtpassword@ftp.mysite.com/myFolder/myFile.txt]

Both are ok when I'm connecting my QV.

But what if I want to access into an MS Access database via FTP ? I'm trying to do something like this, but it's not working :

ODBC CONNECT TO [MS Access Database;DBQ=ftp://user:password@ftp.mysite.es/myFolder/myDatabase.accdb];password@ftp.mysite.es/myFolder/myDatabase.accdb];

Anybody knows what I'm doing wrong?

Many thanks in advance.

Regards, Marcel.