Vba Access Download File From Internet

I am using the following VBA Function in Access 2010 to download a file from the Internet. Sony Camcorder Serial Number Lookup on this page. This Function will be used to distribute a new Access Front-End application connected to MySQL Back-End server. The problem with the code below is, once the file has been downloaded on the remote machine it will remain in cached.

Therefore, when the next update is published, it will now be downloaded. It is being pulled from the Cached folder on the local machine.

Visual Basic VBA Barcode Macro & Functions Tutorial. >Pa Vei Arbeidsbok Pdf To Jpg on this page. Barcode Macros & VBA Functions for Microsoft. Download Free Excel Templates, Chart Templates.

A workaround is to add a unique id at the end of the file name like ' to make it unique each time. Is there any modification to the code below that would force it to download the file from the url link instead of using the Cached folder on the local machine???? See if you can delete the file from the cache first. Add this declaration to the top of your module where your function is. Private Declare Function DeleteUrlCacheEntry Lib 'wininet.dll' Alias _ 'DeleteUrlCacheEntryA' (ByVal lpszUrlName As String) As Long Select all Then in your function: strURLParam = 'strFilenameParam = 'C: Temp MyApp.accdb' DeleteUrlCacheEntry strURLParam returnValue = URLDownloadToFile(0, strURLParam, strFilenameParam, 0, 0) Select all.