Error in update

[Tonatiuh]

I'm getting this error when try to update a date.

Run-time error '-2147467259 (80004005)':
Query based update failed. The row to update could not be found.

I'm update another dates inclusive in the same table without problems.

Any idea bout it?

[Clunietp]

does this happen randomly or on certain records?

are you including the primary key of your table in your recordset?

[bbUFO]

Is the record changed when you try to Update it?
Make sure no other application changing the same record.

[Tonatiuh]

All fields and records give me the error.

My app was in VB5 and there was no problems when 2 user inclusive updated the same record. I recompile the App in VB6. And begin to have this problems.

Any idea?

[DrewDog_21]

I have had that same problem when using Access databases and have found that it usually occurs on the same record. Sometimes (but not always) it works to run the Compress and Repair Database tool from Access.

[Tonatiuh]

I'm using FoxPro as database. I have been using since lot of time and never have this kind of problems.

Thanks by anyway DrewDog

[Tonatiuh]

My app access to a FoxPro database into a Novell Netware 5.0 file server. When two users open and try to update the same recordset, I get an error:

Run-time error '-2147467259 (80004005)':
Query based update failed. The row to update could not be found.

How can I avoid my app of this problem? How can I lock the recods updating and how another client that try to update the same records can know that are locked an wait for the updating (in the another client) ends? Or desists of updating?

I'm using VB6 and ADO 2.1. My App runs in Win 9x/NT use a DSN ODBC to connect to database.