updatable recordset?

[RP]

Hello, in an earlier post I asked about connection.open options. The DSNless
version seemedto work fine, but now I am having trouble getting a record set
to updatable. I am not sure if this has to do with the open method on either
of the recordset or the connection.

I get various version of

"Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
/cosmetic/save.asp, line 79"

or

a.. Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/cosmetic/save.asp, line 62

Here is the connection setup I am using.

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\inetpub\wwwroot\cosmetic\data.mdb;User Id=admin;Password=;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "tblForum", conn, 3, adCmdTable

Thanks
Richard

[Atrax]

you'll find this question answered clearly and conciseley at
www.aspfaq.com

just plug the error code into the 'search' box.

________________________________________
Why? Why was I programmed to feel pain?

Atrax. MVP, IIS
http://rtfm.atrax.co.uk/

newsflash : Atrax.Richedit 1.0 now released.
click the link above!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!