Experts Exchange Search Results

1 - 1 of 1 containing alltags:("VBA, Run time error 3709") (0.001 seconds)

SQL Query Syntax 1

Microsoft Office Suite 1

Writing VBA code to run SQL query with ADODB connection and ...

Tags: Microsoft, Excel, 2002, VBA, Run time error 3709, Run-time error 3709: The connection cannot be used to...

I'm a little new to running queries via Excel and am getting the above error but can't figure out why. I'm trying to run an Access query via Excel VBA, the query runs ok in Access. Thanks so much.

http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23427834.html

Zones: SQL Syntax, Ms Office Suite, MS ExcelDate Answered: 05/23/2008 Grade: A Views: 153