Welcome to Mera Windows Community !

Buddy....I think you have to execute SQL queries to add, delete or for data manipulation......using VB...

Here is a example, to add or insert data into table.

Sub AddRecord()

    Dim dbs As Database

    ' Modify this line to include the path to database file on your computer.
    Set dbs = OpenDatabase("MyDatabase.mdb")
   
    'Create a new record in the Employees table. The first name is Ramesh, the last name is Kumar, and the job title is Trainee.

    dbs.Execute " INSERT INTO Employees " _
        & "(FirstName,LastName, Title) VALUES " _
        & "('Ramesh', 'Kumar', 'Trainee');"
              
    dbs.Close

End Sub