Jul 29 2021 04:16 AM
In an Access application with 5 users, an ODBC is set up locally as a System DSN for each user. Since yesterday, one of the users got the message "No connection to the database". All other users could continue working normally.
The existing ODBC could no longer be edited, not even as an administrator.
I created a new DSN user already, but it doesn't work.
Jul 29 2021 06:17 AM
This kind of information can help find the problem....
Jul 29 2021 11:03 PM
Jul 30 2021 06:13 AM
@AtanasM
"Can you log into the server from this user's computer with your own login? No" [emphasis added]
That suggests the problem is NOT the DSN. That suggests the problem is with the connection between that computer and the server. I should have asked also, if this user can log in using their credentials from a different computer (that would help confirm the diagnosis).
It could be a firewall problem on that computer, for example. If recent updates to the Windows OS were made, that could also be implicated. I think you need to focus, not on the DSN itself, but on the connectivity between that one computer and the database on the server.