Add record to Access DB
Posted on 2006-11-28
Trying to insert a new record into an Access 2003 DB. I have added a reference to M$ ActiveX Data Objects 2.5 Library
Using Code below that I got from another post here:
Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & App.Path & "\logger.mdb"
SQLstr = "INSERT INTO Log (Direction, Local) values ('1','2')"
I get no errors but no data is added.