[2005] Opening database from FTP server without downloading it

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!

I think you may need to use windows scripting.

that sounds completely new to me, any examples?

VB Code:

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

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

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.

This is not a job for FTP.

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

Quote:

---

Originally Posted by darktown

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...