How to install a DSN for MS Access in Windows 7-32 bit?

Asked By 80 points N/A Posted on -

Hello Friends,

How can I install a DSN for Microsoft Access in Windows 7 32 bit?

I have a MacBook Pro which utilizing boot camp. I have windows 7 and I installed MS Access 2007 on my windows 7. All things were going all right. On the other hand when I attempt to add a DSN, it did not work. It Send me an error message and stating that DSN does not equal or match. There is an architecture disparity stuck between the driver and the application

I have also installed both access engine 2007 and 2010. At this time what is the solution?

Thank you.


Error Found:

The specified DSN contains an architecture mismatch between the driver and the application.

Answered By 10 points N/A #149909

How to install a DSN for MS Access in Windows 7-32 bit?


Hello Chasee,

You can use 32 bit ODBC drivers to create the DSN. You have to use 32 bit data source administrator to get the 32 bit ODBC drivers.
2007 Office System Driver: Data Connectivity Components
This will download a set of components which will facilitate data transfer between 2007 MS Office to non Microsoft application.
System requirements
Windows 7, Windows Server 2003, Windows Server 2008, Windows Vista, Windows XP
This download works with the following Office program: 
2007 Microsoft Office system
For further instruction and to download please check the link.
Hope this will help you.
Thank you.

Login/Register to Answer

Related Questions