I have what I thought was a simple task. Create an OLEDB connection to an Access2007 MDB data file within SQL Server 2008 R2. Here's my environment:
Windows 7 64-bit OS
SQL Server 2008 R2 Standard 64-bit
Office 2010 32-bit (installed 32-bit because all legacy data needed to be ported)
My first attempt was within SQL Server's Management Studio by navigating to Server Objects - Linked Servers and right-click selecting New Linked Server...
First indication of some trouble began when I didn't see an ODBC Provider for my Access database. After trying a few options, I turned to Google expecting a quick resolution. Here is the beginning of 5 days of going round in circles!!!
Eventually I found some links that led me to potential solutions:
View Complete Post