Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner Ambassador
Partner Ambassador

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.

0 Replies