Commit The Access Data Insert Query as it fire

See more:

MS-Access

when i save data in access through vb.net query the data is not save until the complete function is not done. Is there is any way to save the data as the query executed.
i use this code to save the data please help me in this to save the data as query excecuted

Dim cmdNonQuery As DbCommand = CreateCommand()
        cmdNonQuery.CommandText = tsql
        Try
            cmdNonQuery.ExecuteNonQuery()
        Catch ex As SqlClient.SqlException
            Throw New Exception(ex.Message)
        End Try