How use "Addnew" in a Access DataBase

Hi
In my ASP code ,I have a problem .I want to add a new record in a Access DataBase. But IE reports
error like this
"ADODB.Recordset error'800a0cb3'
The operation requested by the application is not supported by the provider. "
/guestbook/AddUserInfo.asp, line 8

my ASP Code is
"
LocalArray=Application("StoredArray")'line 2

Set conn = server.createobject("adodb.connection")
Set rst=Server.Createobject("ADODB.Recordset")
conn.open "aem","sa", ""
rst.Open "UserInfo",conn , , , adCmdTable
rst.AddNew 'report error line 8
rst(name)=LocalArray(1)
rst(sex)=LocalArray(3)
rst(email)=LocalArray(2)
rst.update
"
thank you
[727 byte] By [Awei Ken] at [2007-11-17 12:59:59]
# 1 Re: How use "Addnew" in a Access DataBase
Try
rst!name instead rst(name) etc

Iouri Boutchkine
iboutchkine@hotmail.com
Iouri at 2007-11-10 3:32:31 >
# 2 Re: How use "Addnew" in a Access DataBase
In order to connect to ADO using the connection object you have to provide the proper connection string specifying the Access mdb file name etc.You can look up the MS web site for the exact syntax, but that is what the error means here.
al_paso at 2007-11-10 3:33:28 >