iis update problem

[necta]

I have problem insert/update sql statement in IIS (the statement…must be an updateable queries..) but not in win98. I wonder if anyone can help me with this. Thank you.

 

[mwolf00]

Can you explain what the problem is in more detail? Maybe you could post the SQL statement that is throwing the error.

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[necta]

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/wem/Insert.asp, line 30

 

[mwolf00]

Maybe you could post the SQL statement that is throwing the error? How about line 30 and the few that proceed it?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)