Access ADO Help ( 4 Views )

1. Hello,
   
   Does anyone know how to access the SQL of a stored query using ADO?
   
   The DAO way to do it is:
   
   Dim DB As DAO.Database
   Dim strSQL As String
   Set DB = CurrentDB
   
   DB.QueryDefs("Some_Query").SQL = strSQL
   
   DB.Close
   
   What's the ADO equivalent of this?
   
   Thanks!
   
   
   (can, British Indian Ocean Territory)


2. I've never tried feeding in the name of a query, but this might work:
   
   

   Code:

   ---

   Set cn = Application.CurrentProject.Connection
                   
Set cmd = New ADODB.Command
With cmd
  .ActiveConnection = cn
    .CommandText = "[Access Query Name Here]"
    .Execute
End With
                   
Set cmd = Nothing
Set cn = Nothing

   ---

   
   
   (þenol, New Caledonia)


3. Hi Florida Doc,
   
   I think you might find something useful from that website regarding ADO query:
   
   http://www.w3schools.com/ado/default.asp
   
   
   (ahmet, Zimbabwe)

Related Topics ... (or search in 1.720.883 topics !)