[2005] Opening database from FTP server without downloading it

[Atheist]

elloooo

As the title says, I'd like to open a database file (access) from an FTP server without downloading it, is this possible?

Thank you!

[skea]

I think you may need to use windows scripting.

[Atheist]

that sounds completely new to me, any examples?

[skea]

Sub btnExample_onclick()
         dim wShell         
         set wshell = createobject("wscript.shell")
         wshell.run ("msaccess ""O:\Databases\Databases\DatabaseName.mdb""")
         wshell.visible=true
         wshell.UserControl = True  
         set wshell = nothing
end sub

[jmcilhinney]

FTP stands for File Transfer Protocol. It is used for transferring files. I think that that says it all.

[Atheist]

The reason I dont wanna download the database is that I dont wanna have to upload and overwrite the entire database file after just editing some small bits.
Since its linked to a website with users making changes a bit now and then, it would be devastating if my application overwrites something that a user had just changed.

[jmcilhinney]

This is not a job for FTP.

[darktown]

Can't you make a direct link to your accessdb in your connectionstring?

[Atheist]

Can't you make a direct link to your accessdb in your connectionstring?

The problem is that I have to specify username and password in order to access the FTP server...