none
How to install MS Access odbc driver in windows 7 32 bit operating system - Very Urgent

    Question

  • Hi all,

    Please anybody can help me that would be very appreciate , How I can install ms access odbc driver and its required dll in windows 7 32 bit operating system . Because that machine is not supplied that required Dlls. Please help very urgent

     


    polachan
    Thursday, July 14, 2011 9:49 AM

Answers

  • A clean Windows 7 (32-bit) has the necessary drivers already installed. So what is your problem, e.g. error message? Do you need a specific version? Run odbcad32.exe from the command line, this tools displays the installed drivers.
    Microsoft MVP Office Access
    https://mvp.support.microsoft.com/profile/Stefan.Hoffmann
    • Marked as answer by polachan Friday, July 15, 2011 3:24 PM
    Thursday, July 14, 2011 10:03 AM
  • polachan wrote:

    Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\attendance\Attendance.mdb;Uid=Admin;Pwd=;

    Yes I am using the same connection in my applkication

    What kind of application is it, i.e. what language/platform?

    and it  is working in windows XP machine even that machine without ms
    office application but not wroking in windows 7.

    Have you tested what Stefan suggested (odbcad32.exe)? If you see Access
    ODBC drivers there and you can use them for setting up a test DSN, it will
    also work from your application. If the problem exists there, too, you have
    a playground for testing until it works. (repair windows, re-install
    driver, ...)


    Peter Doering [MVP Access]

    • Marked as answer by polachan Friday, July 15, 2011 3:25 PM
    Thursday, July 14, 2011 12:38 PM

All replies

  • A clean Windows 7 (32-bit) has the necessary drivers already installed. So what is your problem, e.g. error message? Do you need a specific version? Run odbcad32.exe from the command line, this tools displays the installed drivers.
    Microsoft MVP Office Access
    https://mvp.support.microsoft.com/profile/Stefan.Hoffmann
    • Marked as answer by polachan Friday, July 15, 2011 3:24 PM
    Thursday, July 14, 2011 10:03 AM
  • Many thanks for the reponse to my query,

     I bought a new machine with windows 7 professional 32 bit OS. There is no ms office application supplied with. I am tring to connect MS Acess database from the server , using ODBC but I getting the error message as follows. "SQLSTAT =IM003, Specified driver could not be loaded due to system error 126". Please advice me how to fix this problem.

    The following is the code to connect MS Access. DBMS=ODBC DBParm = ConnectString='Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\attendance\Attendance.mdb;Uid=;Pwd=' AutoCommit=FALSE In every other machine this code is working fine  except windows 7 operating system,

    I think that machine is not supplied Microsoft Access Driver required Dlls.

    it would be very helpful to me if you can advice me how to fix this problem

    With thanks

    Pol


    polachan
    Thursday, July 14, 2011 10:43 AM
  • polachan wrote:

     I bought a new machine with windows 7 professional 32 bit OS. There is
    no ms office application supplied with. I am tring to connect MS Acess
    database from the server , using ODBC but I getting the error message as
    follows. "SQLSTAT =IM003, Specified driver could not be loaded due to
    system error 126". Please advice me how to fix this problem.

    What is the client you are connecting from? Also Access? If so, you canNOT
    use ODBC. It is not supported, you have to use Access onboard functionality
    like TransferDatabase (VBA) or from the menu File - External Data - Link
    ...

    If you are connecting from e.g. a VB application, you can pick a connection
    string from http://www.connectionstrings.com/access, e.g.
    Driver={Microsoft Access Driver
    (*.mdb)};Dbq=C:\attendance\Attendance.mdb;Uid=Admin;Pwd=;


    Peter Doering [MVP Access]

    Thursday, July 14, 2011 11:20 AM
  • Driver={Microsoft Access Driver
    (*.mdb)};Dbq=C:\attendance\Attendance.mdb;Uid=Admin;Pwd=;

    Yes I am using the same connection in my applkication and it  is working in windows XP machine even that machine without ms office application but not wroking in windows 7.

    Please help


    polachan
    Thursday, July 14, 2011 11:33 AM
  • Try running a system repair from the command line wit sfc /scannow.
    Microsoft MVP Office Access
    https://mvp.support.microsoft.com/profile/Stefan.Hoffmann
    Thursday, July 14, 2011 12:07 PM
  • polachan wrote:

    Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\attendance\Attendance.mdb;Uid=Admin;Pwd=;

    Yes I am using the same connection in my applkication

    What kind of application is it, i.e. what language/platform?

    and it  is working in windows XP machine even that machine without ms
    office application but not wroking in windows 7.

    Have you tested what Stefan suggested (odbcad32.exe)? If you see Access
    ODBC drivers there and you can use them for setting up a test DSN, it will
    also work from your application. If the problem exists there, too, you have
    a playground for testing until it works. (repair windows, re-install
    driver, ...)


    Peter Doering [MVP Access]

    • Marked as answer by polachan Friday, July 15, 2011 3:25 PM
    Thursday, July 14, 2011 12:38 PM
  • A clean Windows 7 (32-bit) has the necessary drivers already installed. So what is your problem, e.g. error message? Do you need a specific version? Run odbcad32.exe from the command line, this tools displays the installed drivers.
    Microsoft MVP Office Access
    https://mvp.support.microsoft.com/profile/Stefan.Hoffmann

    Many thanks
    polachan
    Friday, July 15, 2011 3:25 PM
  • Many thanks for your all response. I fixed that issue by selecting correct odbc driver .

     

    Many thanks

     


    polachan
    Friday, July 15, 2011 3:26 PM