msaccess error

this is the piece of code i am using to insert values in to my msacces database.i get the error "No value given for one or more required parameters".
can anyone help me .
the database contains 1 table namely "table1 " and table contains 2 fields id and name.
dbpath="D:\MR20594\databases\db2.mdb"
Set conn = CreateObject("ADODB.Connection")
conn.provider="Microsoft.Jet.OLEDB.4.0"
conn.open dbpath
sqlquery = "Insert INTO table1 Values(3,Jack)"
Set rs = CreateObject("ADODB.Recordset")
rs.open sqlquery,conn
 

I think this:

sqlquery = "Insert INTO table1 Values(3,Jack)"

may need to be this:

sqlquery = "Insert INTO table1 Values(3,'Jack')"

ebgreen ,thanks for the assistance .i'll try it out .