Are you clicking on a hyperlink field or are you using VBA FollowHyperlink?

I posted your question to ChatGPT. Here's what it said:

The warning you are encountering is a built-in Microsoft Access security feature designed to alert users about potential risks when following hyperlinks to other databases. Since this issue persists despite adjustments in the Trust Center and reverting to earlier Access versions, Microsoft may have introduced stricter security measures through a recent update.

Here are some steps to address this issue:

1. Ensure Trusted Locations Are Properly Configured:
   - Open Access and go to File > Options > Trust Center > Trust Center Settings > Trusted Locations.
   - Confirm the database's directory (e.g., `C:\Users\Colin\OneDrive\Documents\Access`) is listed as a trusted location. Ensure the "Subfolders of this location are also trusted" option is checked.
   - If the database resides on a network drive, enable "Allow Trusted Locations on my network."

2. Enable VBA Bypass for Hyperlinks:
   - Instead of using hyperlinks, create a button or event in VBA to open the target database. Example code:

Code

     Application.FollowHyperlink "C:\Users\Colin\OneDrive\Documents\Access\AccessYTD.accdb"
Copy

     This method often bypasses the hyperlink warning, as it uses a trusted VBA command.

3. Use Windows File Association:
   - If you prefer hyperlinks, ensure `.accdb` files are associated with Microsoft Access in your system settings:
     - Right-click any `.accdb` file, choose Properties, and check the Opens with section. Set it to Microsoft Access if it's not already.

4. Check the Recent Updates:
   - Verify if a recent Microsoft Office update introduced this stricter behavior. You can test by rolling back to a version before December:
     - Open Command Prompt as Administrator.
     - Run the following command (replace `VersionNumber` with the specific version):

Code

       cd %programfiles%\Common Files\Microsoft Shared\ClickToRun
       officec2rclient.exe /update user updatetoversion=16.0.xxxxx.xxxx
Copy

       You can look up older version numbers on Microsoft's update history page.

5. Disable Protected View:
   - Open Access and navigate to File > Options > Trust Center > Trust Center Settings > Protected View.
   - Uncheck the options for Protected View if they are enabled. These settings sometimes interact with hyperlink security warnings.

6. Advanced Registry Edit:
   - As a last resort, you can disable the hyperlink warning through the Windows Registry. This is not recommended for production systems unless you're certain the database is safe:
     - Press `Win + R`, type `regedit`, and press Enter.
     - Navigate to:

Code

       HKEY_CURRENT_USER\Software\Microsoft\Office\\Access\Security
Copy

     - Look for a key named `DisableHyperlinkWarning` (create it if it doesn't exist as a `DWORD`).
     - Set its value to `1` to disable the warning.

If the issue persists, Microsoft support may be able to confirm if this is part of a recent update. In that case, you can also check if your database has any other macros, VBA code, or linked files that might inadvertently trigger additional security measures.

Be careful with the last one. I have NOT tried all of these myself. This is just what GPT said.

ShellEx: Access Developer 31
Code Vault: Shell Execute 64-bit

A massive thanks for Richard and Kevin.

Richard held my hand after Kevin gave me the clue on what to do, touch of the forelock to both of you.  

I used the extended cut video of the Database Launcher video to get around this tedious problem.  Hell of a hack, but it worked.  Many many thanks.

This is how I got rid of it on my computer.
How to turn off the "Unsafe" warning message when clicking a hyperlink.

You can simply turn off this feature from the registry....

Open the registry editor by typing "regedit" in the "run" command

Browse to the following location in the registry
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common

and search for a key called "Security"

If the Security key already exists under the Common key, then select it.
If it doesn't exist already then create it via:
Edit-> New-> Key
4. In the Security Key on the right side ,create a new DWORD Value via
Edit-> New-> DWORD Value

Value name: DisableHyperlinkWarning
Value Type: REG_DWORD
Value: 1

NB : When this key is set to 0 or is missing, the security warning will show again.
Close you registry and restart .....

Sandra
Many thanks for taking the time to set out how to change the registry to get around this annoying problem. Much appreciated.
Colin

Word of warning: Please be EXTREMLY CAREFUL if editing the Registry manually.

Kevin - thanks for the heads up.

It was interesting to read how Sandra has overcome the problem by changing the Registry but I will stick with the method highlighted by you and described by Richard in the extended cut video of the Database Launcher video to avoid the warning message.