I'm wondering which is better in term of speed and performance.

SQL$ = " select * myTable where 1=0 "
Set myrecordset= New Recordset
myrecordset.Open RecSource$, MainDb, adOpenStatic, adLockOptimistic
myrecordset.AddNew
myrecordset.Fields("name") = "James"
myrecordset.Update
myrecordset.Close

OR

SQL$ = "INSERT INTO myTable(name) VALUES('James')"
myrecordset.Open SQL$, MainDb, adOpenStatic, adLockOptimistic


Please give views and opinions. Thankx.

For the 1st "select * myTable where 1=0" , would it return the record even if the "where 1=0" which is false?
Other than that I do agree with you.

Oic, thanks for the enlightenment.