-
Access -> SQL Server Express via ADO
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules