>>What are the problems, specifically, you are running into with updating or deleting data?
>
>Well here is what my code looks like. The records were tabled on a previous page and the records to be
>deleted were marked with a checkbox storing the records unique userid.
>
>
>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 "user",DBmiym,adOpenDynamic,adLockOptimistic,adCmdTable
>
>for each p_del in request("p_del")
> userSet.Find "userid = " & p_userid next
> userSet.Delete
> userSet.Update
>next for
>
>
>
>This generates a Can't update cursor error. I then tried to remove the UPDATE because I wasn't 100%
>sure it was needed or not. That didn't work either.
>
>Suggestions?
Peter,
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.