-
Im converting a program from DAO to ADO to give it access to more types of databases. I know I can base my recordsource on a SQL statement but I how do I perform Action Queries on my underlying data. Such as... "Delete * from mytable where data = junk" . Sorry if this is a real beginner question. Is their anything comparable to the DAO command database.execute (<statement> )?
-
It is only a beginner question if you already know ADO! Convert all to ADO ASAP -- MS Access 2000 can only be accessed via ADO and NOT DAO! I found out the hard way. Anyways....
dim cn as new connection
cn.connectionstring = <yourconnectingstringhere.
'delete everything in table
cn.execute "delete from mytable"
cn.close
set cn = nothing
HTH
Tom
