How use "Addnew" in a Access DataBase

[Awei Ken]

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

[Iouri]

Try
rst!name instead rst(name) etc

Iouri Boutchkine
iboutchkine@hotmail.com

[al_paso]

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.