'Suddenly the connection between excel and access doesn't work


I have a program developed for more than 15 years in excel VBA.
This program is stored in an excel book and is connected to an access database located on a file server, which stores the budget data for our activity, customer information, etc...
This program connects to the access database using sql queries. These queries are debugged for a long time and do not present errors.
Currently there are 5 users using the program and it works correctly for all of them.
One day it suddenly started giving me an error. Only for me and not to the other users.
The error it gives me is when making a query to the database. Not a specific query, it can be any query. A query that works correctly then stops working. A query that in another computer works fine in mine gives an error.
I have error handling and the error it gives is:
err.description -> Unspecified error
err.number -> -2147467259

The problem is that I don't know where to look for the error.
As the program had worked correctly on my current computer for more than two years, I suspect that there has been some update of OneDrive, or Office 365, or the Avast antivirus, etc... that interferes with the connection between excel and access.
I have formatted the computer, installed only Office 365 alone and it continues to give an error!! That's why I suspect it might be something to do with my Office365 account's security settings or similar.
My feeling is that it allows you to make the connection with access at first but after a short time something is activated and prevents the connection.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source