jet error in ASP: Could not delete from specified tables.
From: dee (dee_at_syra.net)
Date: 01/27/05
- Next message: Ignacio Salís: "Error: Visual Basic 6.0 SP3 - ACCESS W2000"
- Previous message: dee: "jet error: Operation must use an updateable query."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 Jan 2005 14:25:17 -0500
Hi
I was running the following ASP code successfully on a Windows 2000 Pro SP2
with Access 97 and 2002 installed.
Now I am running it in Windows XP Pro SP2/ IIS 5.1 with only Access 2003
installed.
IN the new environment i still can successfully Create a Connection object
abd do SELECT queries. But when I want to add or delete rows I get the the
followings erros messages in IExplorer 6.0
Running Following:
...
Set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn
cm.CommandText = "INSERT INTO Guestbook (TB1,TB2,TB3,TB4,MB1) VALUES
(?,?,?,?,?)"
cm.Execute
Generates:
In IExplorer:
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
Running Following:
....
Set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn
cm.CommandText = "DELETE FROM Guestbook WHERE ID = " & strIDNum
cm.Execute
Generates:
In IExplorer:
Error Type:
Microsoft JET Database Engine (0x80004005)
Could not delete from specified tables.
I appreciate if someone can help me.
Thanks
Dee
- Next message: Ignacio Salís: "Error: Visual Basic 6.0 SP3 - ACCESS W2000"
- Previous message: dee: "jet error: Operation must use an updateable query."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
