-----Original Message-----
yes, on this one the pk is the multiplier field.
when I tried the INSERT INTO was setting two new values.
the table looks like this:
K KHZ
M MHZ
(it's just a lookup table)
tried to add:
G GHZ
and got the same error.
the only other field in the table is a system produced
replication one, which I assumed that the system would
generate when a row was added (or is there something I
have to do for this to happen?)
Joey
-----Original Message-----
Is there a Primary Key on the table?
when
I
try to write to the db I get the following error:
Microsoft OLE DB Provider for ODBC Drivers
error '800004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query.
/index.asp, line 53
here is my code:
<%
Set objConn - Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=FTSD"
%>
<%
set objCMD = Server.CreateObject("ADODB.Command")
set objCMD.ActiveConnection = objConn
objCMD.CommandText = "UPDATE table_band SET band = 'bob'
WHERE multiplier = 'M'"
objCMD.CommandType = adCmdText
objCMD.Execute
%>
the error line (53) equates to the objCMD.Execute
line
.
