ms-accesshyperlink
Check hyperlink fields on MS-Access if broken without click the links
Is there a way to check an Access Table with many hyperlinks fields and contains hundreds of records if any of these hyperlinks are not working without clicking each link?
Note: All hyperlinks are referring to files & folders.
Solution
You can use my function DownloadFile found at VBA.PictureUrl in an expression in a query, as the function returns 0 (zero) if the URL is live.
IsBroken: CBool(DownloadFile(Nz([YourUrlField]), "C:\Test\Delete.tmp"))
When done, delete C:\Test\Delete.tmp.
- Add Same Items In ListBox
- how to compare sql server data with MS Access data
- Create a query dynamically
- How can I get TSQL from easy MS Access SQL with little to no handiwork?
- How to refresh an access form
- MS Access - Can't Open Any More Tables
- Specifying Color of Columns in MS Access Histogram Chart
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- How to create custom filter based on user input in MS Access
- Multiple users working from same application through ODBC corrupt ms access DB file. What is wrong?
- How to write criteria for query to return dates a year before current date
- c# Cannot open Database - Windows 10 Access 2016
- How to make a Report title dependent on a parameter?
- How select query from record count more than 1 and count more than 2 with custom column (Option) in MS Access
- How do I sort "SELECT INTO" queries that are built on top of each other by their "INTO" / "FROM" table links?
- Access database not closing properly
- How to open form to specific record from datasheet
- MS Access Expression Builder Value from another Table
- I'm getting an Error with my iff statement
- VBA "does not equal" code not stepping through IF statement as expected
- Access VBA For Loop throwing error of "No Current Record" after 1 iteration of code
- MSACCESS.EXE process won't end
- Adding an index to query result
- How can I make a search query disregard punctuation?
- VBA-Json Parse Nested Json
- Microsoft question regarding IIf statement or a better solution
- How select query from record count more than 2 with custom column (Option) in MS Access
- How do I enter a parameter to limit the results of a query using ADODB.connection & ADODB.Recordset using Excel VBA?
- How do I get my Mailmerge VBA routine not to show dialog box and to run automatically
- Sql TRANSFORM with calculation time in MS Access