Our company just upgraded everyone from Access 2010 on a Windows 7 device to Access 2016 on a Windows 10 device.
One of the problems encountered is as follows, but only happens to one person, which has me puzzled.
There is a line of code in a few of the databases that uses a global password and username to connect to a data warehouse, via an ODBC connection.
This code works fine for all bar one user. That one person gets a message: "Run Time Error: 3151 ODBC Connection to {database name} Failed".
Clicking on <debug> highlights the 'Set db...' line.
If I go to the data tab within that user's front end and try to connect to the database using the same username and password, it connects perfectly without any errors. so I know he has ODBC connections set up.
Tried without success:
One of the problems encountered is as follows, but only happens to one person, which has me puzzled.
There is a line of code in a few of the databases that uses a global password and username to connect to a data warehouse, via an ODBC connection.
Code:
Dim db as database
Set db = OpenDatabase("", False, "ODBC;DSN={database name};UID={user id};PWD={password};DATABASE={database name};"
Clicking on <debug> highlights the 'Set db...' line.
If I go to the data tab within that user's front end and try to connect to the database using the same username and password, it connects perfectly without any errors. so I know he has ODBC connections set up.
Tried without success:
- Opening a different front end from the same user's PC
- Compact and repair
- Replacing that user's front end with a new version