This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I inherited several Access databases when my coworker died suddenly. These contain sql pass through queries that I am unable to run as they are looking for his odbc connection with his stored password. How do I change the connection to my credentials so that the queries will run?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Thank you for your suggestion, but I was told it wouldn't work in my situation. Instead, I was able to change the user ID and password in the properties of each query and the queries ran. So, the problem is solved.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I'm curious as to who told you that and whether you even tried it.
Thank you for your suggestion, but I was told it wouldn't work in my situation. Instead, I was able to change the user ID and password in the properties of each query and the queries ran. So, the problem is solved.
You need to run the ODBC connection wizard to modify the DSN.
Assuming the Office installation is 32 bit, you would run the the odbcad32.exe file in the Windows\SYSWOW folder. If the Office installation is 64 bit, you can run the wizard from Administration tools in Control Panel.