ADO is a nasty little piece of work, that only works when it feels like it...i have similar programs all with similar code, some choose to work while others choose not to..
unless i am needing to preform sql searchs, display into a datatable or have the database available to multiple users - i much prefer to use DAO
contuary to what alot of people think DAO does still work with the new versions of MS Access, you simply have to go into project references and tell vb to use DAO 3.6....
anyway now to the code...
as started above first go into project preferences and tick the DAO 3.6
dim mydata as DAO.Database
dim myrecord as DAO.RECORDSET
private sub command1_click()
set mydata = open database("path to database")
set myrecord = database.recordset("tablename)
myrecord.Movelast
myrecord.Add
myrecord!NAME = "johnsmith" or text1.text
myrecord.update
end sub
Rob
hope this helps