running pass through using ado

[Jonathan Crawford]

Hi

I think I can run a pass through using DAO but can't
find an ADO equivalent and am struggling to google it

I would be grateful for a hint

thanks

jonathan

--

===============
Jonathan Crawford
01273 440018
07799 068570
fax 01273 380221
(e-mail address removed)
===============

 

[Alex White MCDBA MCSE]

Within ADP

2 slightly different ways

*** Air code ***

dim adoCn as new adodb.connection

adoCn = currentproject.connection

adoCn.execute "Update TblTest Set test_id=1 where test_id=''"

*** second idea the one I use ***

currentproject.connection.execute "Update TblTest Set test_id=1 where
test_id=''"


neither has been tested but both should be able to pass native SQL to SQL
server






Within MDB

*** Air code ***

dim adoCn as new adodb.connection
' open the adoCn to connect to the SQL server


adoCn.execute "Update TblTest Set test_id=1 where test_id=''"


you will need to modify them to get them to work, the basic idea here is you
are executing from the connection object