[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!
Re: [2005] Opening database from FTP server without downloading it
I think you may need to use windows scripting.
Re: [2005] Opening database from FTP server without downloading it
that sounds completely new to me, any examples?
Re: [2005] Opening database from FTP server without downloading it
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
Re: [2005] Opening database from FTP server without downloading it
FTP stands for File Transfer Protocol. It is used for transferring files. I think that that says it all.
Re: [2005] Opening database from FTP server without downloading it
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.
Re: [2005] Opening database from FTP server without downloading it
This is not a job for FTP.
Re: [2005] Opening database from FTP server without downloading it
Can't you make a direct link to your accessdb in your connectionstring?
Re: [2005] Opening database from FTP server without downloading it
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...