I have 2 procedures to (1) Create an SQL Server Exp DB (2) SELECT INTO a table from an Access DB into a table in the Server DB - both done with a single SQL statement using an ADODB.Connection Object.

Although I have some concerns with the Connection Objects .state property only supporting Open and Closed, both procedures will work. However, the 2nd is dependent upon the Server configuration to support 'Ad Hoc Remote Queries' [A.K.A. Ad Hoc Distributed Queries].

Question: is there a way to programmatically determine if this [configuration] is enabled and change if not?

Stan