I have an Access 2010 front end connecting to a SQL Server 2014 back end. I've got SSMS 2014 installed on my machine, and everything was working fine. (Running Win7 64-bit with 64-bit Office.)
Long story short, in trying to trouble shoot an end user problem, I attempted to install AccessDatabaseEngine_x64.exe
from Microsoft. (I ended up getting it from downloads.com because the MS link wouldn't download it - I should have taken that as a clue.)
Installing that didn't help the issue, so I uninstalled and rebooted my machine. Now, when my Access application is attempting to connect to the SQL Server via this code:
Dim ConfigRS As New ADODB.Recordset
Dim SQLString As String
SQLString = "SELECT <fields> " & _
"FROM <table> " & _
"WHERE <condition>"
ConfigRS.Open Source:=SQLString, ActiveConnection:=CurrentProject.Connection
I usually get this error (server name, starts with 'c', blacked out), though sometimes it works just fine:
I can browse the linked tables from within Access, I can select from the tables in SSMS with no problem, I just cannot open an ADODB query via code.
The only thing that's changed today is the installation and uninstallation of AccessDatabaseEngine
.
- Does anyone know of specific files I need remove to finish removing all traces of
AccessDatabaseEngine
? - Would it be easier to reinstall SSMS to ensure all the proper drivers are in place?
AccessDatabaseEngine_x64.exe
. That leads me to believe that my method was sound and that the install broke it. If, though, you think making the changes will make it work, even with the remains of that install lurking about, I'll pursue that option. – FreeMan Nov 2 '15 at 13:13