Delete All Record in a database Table in Visual Basic 6

Here is a sample program that is being provided by my close friend, business partner and fellow software engineer Sir Larry Dave Emol. He created this program using Microsoft Visual Basic 6 and Microsoft Access to Delete All Record in a database Table in VB6. 

I am currently accepting programming work, IT projects, school and application development, programming projects, thesis and capstone projects, IT consulting work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com.

Sample Program Output

Program Listing

FORM CODES

Private Sub Command3_Click()
On Error Resume Next
Call dbConn
conn.Execute "DELETE FROM tblInfo"
MsgBox "All information has been successfully deleted!", vbInformation
Call SQLDB(Me.AdoCon, "Select * from tblInfo order by LASTNAME Desc")
Set Me.DataGrid1.DataSource = Me.AdoCon
End Sub


Private Sub Form_Activate()
On Error Resume Next
Call SQLDB(Me.AdoCon, "Select * from tblInfo order by LASTNAME Desc")
Set Me.DataGrid1.DataSource = Me.AdoCon
End Sub

MODULE CODES

Option Explicit

'variables for ADODB

Public conn As New ADODB.Connection

Public ctr As Integer

Public Function AppDir() As String

    If Right$(App.Path, 1) = "\" Then

        AppDir = App.Path

    Else

        AppDir = App.Path & "\"

    End If

End Function

Public Sub dbConn()

  Set conn = New ADODB.Connection

  conn.ConnectionString = strConn2

  conn.Open

End Sub

Public Function strConn2() As String

  strConn2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "

End Function

Public Sub SQLDB(adoObj As Adodc, AdoRec As String) 'for SQL Recordsource

    'Loads the database and provides the database password

    adoObj.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & AppDir & "Tutorial.mdb;Persist Security Info=False;Jet OLEDB:Database Password = "

    

    'Sets the command type to Table

    adoObj.CommandType = adCmdText

    

    'Loads the source table of info

    adoObj.RecordSource = AdoRec

    'refreshes database status

     adoObj.Refresh

End Sub

DOWNLOAD SOURCE CODE HERE