jimcilhinney,
Dim Connection As New OleDb.OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source = C:/candidates.mdb")
Dim insertCommand As New OleDb.OleDbCommand("INSERT INTO tblCandidates (CandidateID, Name, Course, Address, CourseID) VALUES ('Maganizo','Monawe','MMT','NNT2','SRT')"...