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.
Please open the 32 bit ODBC Administrator tool with the following command in run:
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.