none
Cannot find 32-bit driver Microsoft Access Driver (*.mdb, *.accdb) for 32 bit applications running on 64-bit Vista RRS feed

  • Question

  • I have a 32 bit visual basic application running on a 64-bit Vista O/S.  I need to connect to an .accdb database.  The 32 bit ODBC driver manager shows that the driver Microsoft Access Driver (*.mdb, *.accdb) is NOT installed.  I cannot seem to figure out how to get it installed.  I have Access 2010 on the computer and I have tried installed the 64 bit Access database engine hoping it would put both the 64 and 32 bit ODBC drivers on the machine.  No such luck. 

    Does anyone know how to get the 32 bit Microsoft Access Driver (*.mdb, *.accdb) installed on a 64 bit machine?


    Andy
    Saturday, June 25, 2011 3:18 AM

Answers

  • I just have the 32-bit drivers and 32-bit Office 2007 installed. The install packages won't allow you to install both.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by andy pelkey Friday, August 19, 2011 1:43 PM
    Wednesday, August 10, 2011 2:01 AM

All replies

  • So, you have tried installing the 64bit version of Microsoft Access Database Engine 2010 Redistributable? The link contains a 32bit version package, could you please try the 32bit one?

     

    By the way, may I know the full error message? What connect string  you're using?


    Eric Yang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, June 27, 2011 9:25 AM
  • Thank you for the reply. Sorry it has taken me so long to respond.  I did not receive any notification that someone had replied!

    I have tried installing both the 32 and 64 bit 2010 redistributables on my 64 bit Vista computer.  The 32 bit version tells me to install the 64 bit version and the 64 bit version installs only the 64 bit drivers (no 32 bit).

    Andy


    Andy
    Tuesday, July 5, 2011 7:36 PM
  • The 32 bit version tells me to install the 64 bit version

     

    Did you encounter any error/warning when install 32bit version of Access Database Engine 2010? What's the full error/warning message?


    Eric Yang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, July 7, 2011 2:39 AM
  • No errors.  It just tells me the product cannot be installed on a 64-bit system and advises me to install the 64 bit version.
    Andy
    Friday, August 5, 2011 5:45 PM
  • I don't think I've seen this issue before. You should be able to install the 32-bit version of the Mirosoft Access Database Engine 2010 under 64-bit Vista. One limitation is that you cannot install both the 32-bit and 64-bit version in the same environment, so if the 64-bit version is already installed you will need to uninstall it first before installing the 32-bit version.

    BTW, the ACE OLEDB Provider is preferred over the ODBC driver since it has better support for Access functionality.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by andy pelkey Friday, August 19, 2011 1:41 PM
    • Unmarked as answer by andy pelkey Friday, August 19, 2011 1:42 PM
    Monday, August 8, 2011 12:07 PM
  • Hi Paul.

    My application has to work with both Access and SQL Server.  I use the ODBC API's to do all data access.  In addition, I have the added requirement to use cursors to page through large amounts of data. 

    Is there another data access method that can meet these two requirements that can use the ACE OLEDB provider you mention?  I don't know of any.


    Andy
    Monday, August 8, 2011 5:40 PM
  • Am I thinking correctly here?  If the 32 bit driver and the 64 bit driver cannot be installed on the same machine, that makes the 32 bit driver pretty much useless.  If you have a 32 bit application that needs the 32 bit driver, your application cannot be installed on a 64 bit operating system because it potentially could conflict with the 64 bit version of the same driver. 

    The reverse is also true isn't it?  If you have a 64 bit application using the 64 bit drivers, you cannot install it on a 64 bit operating system if the 32 bit drivers have already been installed.  Am I missing something?


    Andy
    Tuesday, August 9, 2011 2:22 AM
  • This is correct. It's born out of the limitation that you can't have both the 32-bit and 64-bit versions of Microsoft Office 2007/2010 installed in the same environment. I've considered looking into whether it's actually possible to have both engines installed (the install prevents it) but it's something I haven't gotten around to.

    Using the ODBC API seems like a lot of work. If you want to write somewhat generic data access code you may want to consider using the DbProviderFactory Class:

    http://msdn.microsoft.com/en-us/library/wda6c36e.aspx

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, August 9, 2011 2:30 PM
  • The ODBC APIs are not a lot of work (when you create functions to do common things, it is no more work than any other data access method to be sure).

    Being that the industry is in a transition from 32 bit application to 64 bit application (such that many Windows users will have both types of applications installed on their computers), this problem is effectively the 'kiss of death' for Microsoft Access ODBC drivers.  Am I wrong?

    I will at the DBProviderFactory class link you sent. 

    Thanks!


    Andy
    Tuesday, August 9, 2011 4:41 PM
  • AFAIK the Access ODBC driver is still supported, however; I don't believe that they support all the functionality that is native to Microsoft Access. That was my experience several years ago when attempting to run Access DDL/DML statements through ADOX and Microsoft Access ODBC driver. I don't really know what changes have been made since support for the 2007/2010 versions of Microsoft Access has been added.

    BTW, I have the 32-bit Access Database Engine installed under 64-bit Windows 7 and I do see the Microsoft Access Driver.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, August 9, 2011 5:12 PM
  • Where did you get the installation program from?  I have 64 bit Vista.  I will try it again.  If it does not work, I will try it on a 64 bit windows 7 computer to see if that matters.


    Andy
    Tuesday, August 9, 2011 5:18 PM
  • Same link that Eric posted (for 2010):

    http://www.microsoft.com/download/en/details.aspx?id=13255

    Below is from the 2007 version link:

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

     


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, August 9, 2011 5:40 PM
  • I used the first option (Access Drivers for Access 2010) to download the install program.  I ran it on my 64-bit Vista computer.  The message I get is:

    You cannot install the 32-bit version of Microsoft Access Database Engine 2010 because you currently have 64-bit Office products installed.

    It then goes on to tell me I have to downgrade to the 32 bit version of Office to install these drivers.  Why would this be if you have both sets of drivers installed on your computer?

     


    Andy
    Wednesday, August 10, 2011 1:24 AM
  • I just have the 32-bit drivers and 32-bit Office 2007 installed. The install packages won't allow you to install both.


    Paul ~~~~ Microsoft MVP (Visual Basic)
    • Marked as answer by andy pelkey Friday, August 19, 2011 1:43 PM
    Wednesday, August 10, 2011 2:01 AM
  • Sorry, I still don't get it.  If someone has 64 bit Office but needs to enable a 32 bit app to connect to Access, and if the 32 bit Access driver only includes (*.mdb), how can I go about updating it to (*.mdb, *.accdb) if all of the 32 bit driver update utilities won't run because 64 bit Office is installed?

    Thanks,

    Thursday, November 17, 2011 12:15 AM
  • I have the same problem. I need to upgrade the MS Access ODBC drivers to version 12 for use with a certain software package. But when I download the 32bit install via the link above and try to install it simply says "You cannot install the 32 bit version of [etc...] because you currently have 64 bit office products installed."

    So as andy pelkey and pnagy say above, if you have 64bit office installed it does not appear possible to install connectivity for 32bit apps. Brilliant work Microsoft! I hardly think it possible that 64bit and 32bit connectivity could not co-exist on the same machine. Lazy coding on behalf of whoever created the install package me thinks.  

    Friday, July 6, 2012 12:57 AM
  • This thread is a bit dated now. Apparently there is an undocumented command line argument that enables you to perform the install. Try running the install using the /passive argument.


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Friday, July 6, 2012 2:14 AM
  • I hope that nobody at Microsoft thinks that this undocumented command line argument is a solution to this problem.  Users are not going to know how to even kick off this install from a command prompt.  Even more important, 32-bit application that need the 32-bit driver need to install it with their own windows install (such as an installer project built with visual studio) and be confident it will work with the 64-bit version of office already installed.  The fact that it is undocumented doesn't give me a lot of confidence that it will not cause problems on end-user machines.  Not something I want to even try without someone at Microsoft willing to troubleshoot what happens with things go south!

    Thank You! - Andy



    • Edited by apelkey Friday, July 6, 2012 3:22 AM
    Friday, July 6, 2012 3:21 AM
  • I probably should have clarified that while using this argument will allow you to install both (and it seems to work), Microsoft still does not support the side-by-side installation of 32-bit and 64-bit versions of Office and their dependent components.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Friday, July 6, 2012 1:16 PM
  • If you have 64bit office 2010 installed then install 32 bit office 2007 drivers or vice versa.
    Saturday, April 19, 2014 11:45 AM