Images in Microsoft Access

15 months ago

Check if Hyperlink Broken Upload Images Link
Bruno Segers
4 months ago

Hi Richard,

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.

https://stackoverflow.com/questions/68539466/check-hyperlink-fields-on-ms-access-if-broken-without-click-the-links

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.

Mrs. Segers Bruno.
From Belgium

Richard Rost
4 months ago

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?

Bruno Segers
4 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.

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

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Images Comments