[thelist] asp update existing record
Lightning
oktellme at earthlink.net
Fri Jan 23 14:22:54 CST 2004
I am trying to update an existing record. The sql statement is fine.
dsn="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\inetpub\wwwroot\WhiteLightening\db\buzz.mdb;Persist Security
Info=False"
Source=c:\webspace\stpsecureservers\WhiteLightening\WhiteLightening.net\db\b
uzz.mdb;Persist Security Info=False"
set cnBuzzConnection = server.CreateObject("ADODB.Connection")
set rsActivity=Server.CreateObject("ADODB.RecordSet")
rsActivity.Open sql,dsn,,3
rsActivity.close
set rsActivity=nothing
I get this err msg:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/WhiteLightening/www/Buzzell/ActivityUpdate.asp, line 315
I suspect problem is in rsActivity.Open sql,dsn,,3
I can't find out what the two number parameters on the end are SUPPOSED to
be, so I have been reduced to experimenting.
thanks, Laura
More information about the thelist
mailing list