I am wanting to combine several delete statements in one MS Access query.
How do I tell a command to execute a query? I know in SQL Server I would just execute a stored procedure.
Please provide a code example and no links. My IE crashes when I click on a link.
Public Function DeleteSelected() As Boolean
Dim oC As New OleDbCommand
Dim i As Integer
oC = oleCnn.CreateCommand
oC.CommandText = CreateDeleteStatement()
i = oC.ExecuteNonQuery()
Catch ex As Exception
If i > 0 Then