I have downloaded and installed "Microsoft Access Database EngineĢ010 Redistributable" and "2007 Office System Driver: Data Connectivity Components" in different orders to no avail.
I either get 7303, 7399, or something else. Here is the beginning of 5 days of going round in circles!!!Įventually I found some links that led me to potential solutions: Īnd no matter what I do following any of the advice in the posts above, I can't get a successful connection. After trying a few options, I turned to Google expecting a quick resolution. My first attempt was within SQL Server's Management Studio by navigating to Server Objects - Linked Servers and right-click selecting New Linked Server.įirst indication of some trouble began when I didn't see an ODBC Provider for my Access database. Office 2010 32-bit (installed 32-bit because all legacy data needed to be ported) Create an OLEDB connection to an Access2007 MDB data file within SQL Server 2008 R2.