The method they're using is very inefficient. It involves downloading the file to a local test folder. All you really need to do is a DIR command to see if that file exists. I cover that in Access Developer 31 under File I/O.

It would be something like:

If Dir(MyFileName)="" Then
   MsgBox "File Not Found"
Else
   ' Open File Here
End if

Easy enough?

As you say here, yes! ;-)  I downloaded the course and will see how to implement it in a check qwuery. So now and then I can run this is and update the database with an update qwuery.

Bruno.
By the way, Happy new Year! lots of fun this year with all our questions.