none
Unable to create MS Access DSN in Windows 7

    Question

  • Hi

    I want to create a system DSN (Data Source Name) for MS Access database on a Windows 7 system. But the ODBC Data Source Administrator application shows only 2 drivers - SQL Native Client and SQL Server - as available drivers. I am an administrator on this system but surprisingly when the IT guy remotely logged into my system suddenly the list of drivers was populated with a bunch of other drivers including MS Access and I was able to create the DSN, which became unavailable as soon as the IT guy disconnected.

    I think this has to do with account rights and "ownership" settings. Even though I am an administrator I still am missing some rights. The IT guys is not able to figure this out.

    Any ideas/suggestions?

    Thanks

     

    Thursday, December 30, 2010 7:48 PM

All replies

  • Hello Caliguy2010,

    Please open the 32 bit ODBC Administrator tool with the following command in run:

    %windir%\SysWOW64\odbcad32.exe

    You were facing the problem because of having Office 32bit installed on 64 bit of Windows. The above command will provide you access to all the other drivers that you were not able to see in 64 bit version.

    Regards,

    Sumit Kathuria

    Virtual Web Solutions

    Wednesday, December 26, 2012 5:07 PM