Subject Re: Accessing a database that is stored in dropbox From Gaetano D. <gaetanoddRemoveThis@andThatHotmail.com> Date Thu, 19 Aug 2021 06:54:13 +1000 Newsgroups dbase.getting-started On 19/08/21 03:25, Matt Milner wrote: > So what I'm hearing is that there is no way for me to access a database that is stored on the internet. I was trying to update my customers without having them do anything.  I currently have a procedure I can do with their participation. The dropbox folders are stored under C:\Users\<username>\Dropbox\<dropbox folder name> You could try to access the file using that path if you are accessing it from your local computer, but I cannot make any guarantees about the impact on dropbox itself as it may try to sync the file as it is being updated. If your purpose is to access the files over the internet with that link, then I'm afraid this seems impossible with dropbox, I have never heard of a database being accessed over HTTP because a web server "serves" a file, i.e. if it is set up to do that, it could send you the database and you could retrieve it from your downloads folder but it is not capable of allowing you direct access to the file. The only way I can think of would be to get a copy of the file and this can be done easily by replacing the suffix dl=0 with dl=1, that will get you a copy of the file in your downloads folder, but I have never tried to submit that sort of request in a script. It may be possible by combining HTTP oleautomation, I gave it a quick try with responseStream but no luck. I see Richard has posted an option, it worked for me by replacing dl=0 with dl=1, I did have to specify the required action the first time (always save file), but the second time the file ended up straight in the downloads folder. HTH -- Gaetano.