>I have an illusive problem that pops up about once a day. It's the 1585 error. The trouble is, the error comes up when adding a record and values in curval and oldval do not evalute, because no record exists (recno is -1). I have a VB programmer here that is writing to the same table that I'm getting 1585 on. I have finally been able to reporduce the error by having Fox sitting on the record when ADO updates the memo field. Then try to save an added record(Note: added while sitting on record updated by ADO) in Fox and I get 1585. On local testing I can say overwrte changes and that works(even though there is no real change to overwrite, rembember, its a new record). In live enviornment user cannot force update. I cannot get them to turn off this ADO VB $#&%$* so that I can verify it's the true problem. Seeing it happen in the test env doesn't seem to be enough. I have to hear it's a Fox problem. I think the third party data consumer needs to go.
>
>Any advise on why Fox might be seeing this as a 1585 ditry buffer is greaty appreciated.
>
>
>Much Thanks
>Jeff
Jeff,
Record is new and buffered and ADO updates it externally ???
Or it updates existing one you're on and you do an insert (in a row buffered table triggering update for existing) ???
If it's not in a DBC use a DBC and (VFP7 and later) turn DBCevents on to kick the other away - add code to dbc_OpenData, dbc_BeforeOpenTable or dbc_BeforeModifyTable that accepts only if a password is passed or checks attempter is a your VFP app :)
Cetin