After following the video Hyperlinks I have completely adapted my database and now it contains hundreds of local links. These links are distributed via excel export files. When one of my colleagues changes the folder name or file name, the link no longer works. Whatever makes sense. Now I've been looking for a while if I can occasionally activate a query to check these hyperlinks. And I can't find much about this on the internet. Yet I found one site where they discuss this.
Unfortunately, the result is always -1 on all checks. The module where everything is written is far too technical for me to find the error. Would it be possible for you to take a look at this? I think many students will find this code also useful.
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"
' Open File Here
Bruno Segers 5 months ago
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.
By the way, Happy new Year! lots of fun this year with all our questions.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.