How do you perform querydef in vb.net

  • Thread starter Thread starter Turlough
  • Start date Start date
T

Turlough

I want to create a query in an access database - In vb.6 I used the
following syntax

Dim qdfNew As QueryDef
Dim SQL As String
On Error Resume Next

SQL = "select * from QrySubRegData UNION ALL Select * from QrySubBeerData;"

With db
.QueryDefs.Delete "QryUnionResetBase"
Set qdfNew = .CreateQueryDef("QryUnionResetBase", SQL)
End With

How do i do this using oledb in vb.net
 
Back
Top