After migratio accesss db and sharepoitn list link issue

Question

We have migrated from sharepoit onpremisis to online

one of the user reported as below:

Issue is related to hyper linking to SharePoint items from within Microsoft access

User has access database which contains a table with hyperlinks to the entries with migrated SharePoint lists
That will allow their colleagues to use databases search for the item they are intersted in and then click on the hyperlink to open the list item in edit mode

Please refer below screenshots

The hyperlink set up by VBA code and in the code user updated the address to reflect the new o365 site name. However his collegues click on link Microsoft access is unable to open it and display below error message

the link works from other places, it just does not work from with in the access

There is a VBA code i the access database module which sets up links to SharePoint lists, copies data from lists into local tables, adn then drop the links

It is all with in MS access. They hyper links works ok if user uses it immediately after he has set up an dropped the link to the Sharepoint lists , but if users opens access and try the hyperlnk with out first copying the data, the hyperlink gives the error message.

Please suggest what needs to be done.
Thankns