acc2000 ADO, DAO, DOCMD ??

[jayes]

Hi

I want to run an action query in access via code but it needs to use a
system DSN.

A)I tried Docmd - but there was no way i could specify a dsn - is this
correct?
B)DAO - not sure of the syntax

C)I have considered ADO:

dim cnn as adodb.connection
dim myrs as adodb.recordset

set cnn = new adodb.connection
cnn.open "database=jup;UID=accept;PWD=123;DSN=System 11;"

set myrs = cnn.execute("qryQueryName",adExecuteNoRecords)

myrs.close
set myrs = nothing
cnn.close
set cnn = nothing


My question is will this definetly work ??and are there any possible
exceptions that might happen?

Thank You

 

[Tom van Stiphout]

Curious how you are trying to capture the results of the query in a
recordset, and then specify ExecuteNoRecords. You may want to rethink
that.

For correct connection strings check with connectionstrings.com.

Perform the test, and you will know if this definitely works

-Tom.