913 questions
Are you using the 32 bit Access or 64 bit Access? If using 64 bit Access you would need to open the 64 bit ODBC dialog to create the DSN.
ODBC Connection not visible in MS Access
![](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, 33%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Obrad
41
Reputation points
ODBC Connection was created and tested OK.
After opening MS Access I do not see the ODBC created.
Did something change in my settings or some drivers got corrupted?
Not sure how to fix this.
Thank you.
Microsoft 365 and Office | Access | Development
Accepted answer
-
Bob Larson (Access MVP 2008, 2009, 2011) 251 Reputation points2021-08-18T19:33:21.76+00:00 -
Obrad 41 Reputation points
2021-08-18T20:47:15.067+00:00 Hi Bob,
Thank you for your comment.
It does seem to be a driver issue. Selecting 64 bit driver allowed me to create ODBC connection that is visible from Access.
My previous laptop was using 32 bit connections for the MS Office.Best regards,
Sign in to comment -
1 additional answer
Sort by: Most helpful
-
DBG 2,456 Reputation points Volunteer Moderator2021-08-18T19:11:02.517+00:00 Hi. Just curious... If you create a File DSN instead, would it show up in Access?
-
Obrad 41 Reputation points
2021-08-18T19:51:53.843+00:00 Hi ,
Thank you for your comment.Tried creating a test DSN but Access throws in the following error once I try to connect to it.
Sign in to comment -