>Might be a stupid question, but do the data *files* in the "New" folder have read/write priviledges on them for the ISUR account on the website? We had a "cannot update cursor" issue once where we built the site using native VFP tables, and the ISP had only set read/write permissions on the data folder, not the individual files themselves.
>
>Setting the permission on the folder did not actually ripple thgrough to the files. They had to select all of the data files individually and set the permissions. Everything worked fine from there on out.
Well, I checked that or at least tried to.... this is a Windows NT server that I don't have full access to but
under that assumption that it is NT, permissions shouldn't play a factor like UNIX does.
I did have a problem with the rs.Find but I fixed that. It tried every setting for the CursorType and LockType
trying to get past this error message....
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
/new/userdel.asp, line 20
Here is the current code....
dim DBmiym
dim DBpath
set DBmiym=server.createobject("adodb.connection")
DBpath="sourceDB=" & server.mappath("../new")
DBmiym.Open "DRIVER={Microsoft Visual FoxPro Driver}; SourceType=DBF; " & DBpath & "; Exclusive=No"
set userSet=server.createobject("ADODB.RecordSet")
userSet.Open "select * from user",DBmiym,1,3,adCmdText
for each p_del in request("p_del")
userset.find "userid='" & trim(p_del) & "'"
userset.delete <<<<<<<<<--------------------------- This is line 20
userset.update
next
Any suggestions?
Pete
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!