Randy,

>Hi. I have the record locking set to "5" (optimistic row) on the 2 main databases of my project...but not the other dbfs. I get the message "Update Conflict" when I am exiting the entire .exe. The status bar indicates that one of my 2 files w/ optimistic row locking is selected. The message does not allow me to gather any info on the problem. What do I do?

BufferMode 5 is opt. TableBuffering not RowBuff. The Information You're giving ist not very detailed but it sounds as if Your tables suddenly are "surprised they're closing" and quickly try to jump into their boxes.

I guess during the session You are updating several records in one of the buffered tables, maybe You have referential integrity and (accidentally) modify some of the key fields. If You now issue a "QUIT" there is not enough time and order to update the other tables correctly.

Do You know the game where kids walk aroud a group of chairs while the music plays - having always one chair less than children - each kid has to find a chair as soon as the music stops, unfortunately always one kid has to leave (I always ! hated this game)

Sounds a bit like this.

Did You have a look in the debugger or employ some wait windows in order to track when the data gets changed?

I found that sometimes if You have data bound to ComboBoxes You get the tables into a "changed" state though the value itself remains the same. Have a look at such constellations.

Hope this helps a little

If not, please give more details


Regards from Berlin (Sunshine)

Frank