Here are 3 working for Add/Delete/Update Records in a Access File

[mrdutchie]

Thought I would share this with you, since you all helped me out.


*** ADD RECORDS ***
value1 = "hello"
value2 = "there"
Dim mycon As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/database.mdb")
Dim mycmd As OleDbCommand = New OleDbCommand
mycmd.Connection = mycon
mycmd.CommandText = "INSERT Into email (name,email) Values ('" & Value1 & "','" & Value2 & "')"
mycon.Open()
mycmd.ExecuteNonQuery()
mycon.Close()


*** DELETE RECORDS ***
Dim mycon As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/database.mdb")
Dim mycmd As OleDbCommand = New OleDbCommand
mycmd.Connection = mycon
mycmd.CommandText = "DELETE FROM email WHERE name='hello'"
mycon.Open()
mycmd.ExecuteNonQuery()
mycon.Close()


*** UPDATE/EDIT RECORDS ***
Dim mycon As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:/database.mdb")
Dim mycmd As OleDbCommand = New OleDbCommand
mycmd.Connection = mycon
mycmd.CommandText = "UPDATE email SET email='no e-mail' WHERE name='hello'"
mycon.Open()
mycmd.ExecuteNonQuery()
mycon.Close()