Avatar of Barry Lysy
Barry Lysy
Flag for Canada asked on

No 64bit ODBC Administrator driver for MS Access on Windows 2012 R2 Server

The system i am using is Windows 2012  R2.  So when trying to create an ODBC DSN to a MS Access DB, and using 64bit ODBC Admin, there is no MS Access driver to select.  If I use ODBC 32 bit admin, there is a MS Access driver to select.  But after selecting that 32 bit MS Access driver, this error msg appears "Failed to connect to link .... [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application".  Is there an OBDC driver update for the 64bit Windows system that solves this issue?  I looked but couldn't find anything that said for Windows 2012 R2 system.  Any suggestions would be appreciated.  thanks.
Microsoft AccessWindows OSWindows Server 2012

Avatar of undefined
Last Comment
Seth Simmons

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Barry Lysy

ASKER
Thank you Jim.
Seth Simmons

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: 'Jim Dettman (EE MVE)' (https:#a42475881)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

seth2740
Experts-Exchange Cleanup Volunteer
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy