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
- Does anyone know of specific files I need remove to finish removing all traces of
- Would it be easier to reinstall SSMS to ensure all the proper drivers are in place?