INSERT command works, but not with users. 1

[qwert231]

Doing an INSERT command in my ASP page, (Server Side, XP, IIS 5.1 FP 2002.)
The command works from my system, but not from other systems on the Intranet. They can access other pages with SELECT scripts, but I get the error:
Must use an updateable query.

Bogus, it is updateable, and security checks out. The anonymous web users (IUSR and IWAM) both have write/modify rights to the folder, file, (Access.MDB) and the VTI_PVT folders... what else could I be missing.

(This is one of the worst errors Microsoft has blessed us with. So non-descript.)

 

[Dynapen]

How are you doing the update. Access doesn't handle multilple users well, so if you are doing the update using the recodset object, and the RS.Addnew, RS.update command, it may be becuase you have locked the object out until you close the opened recordset.

It could also be in how it is opening the cursor for that object.

 

[qwert231]

Here's the code:
strInsert = "INSERT INTO Basket (JobNumber, PhotoID, BasketID" & strFields & ", LineTotal, [Date]) VALUES ('" & job & "', '" & imgVal & "', '" & bsktNum & strValues & "', '" & totLine & "', '" & Date & "')"
RecInsert strInsert

And here's the sub 'RecInsert':
Sub RecInsert(ins)
Set Conn = Server.CreateObject("ADODB.Connection&quot
Conn.Open strC
Conn.Execute(ins)
Conn.Close
Set Conn = Nothing
End Sub

Tried to keep it simple.

 

[Jonax]

You might want to look at this:

[thread779-174533] This is not a bug - it's an undocumented feature...
;-)