FIFO LIFO problems...

Question

I recently updated a table in a multi-user environment and it seems like it was updated at the same time by 2 users. Data was updated with the same bill number. It didn't increment by 1 like usual. I know it was updated at the same time.
How can I fix this? I've been using this app for years and this is the first time I encounter this.

Answer 1

File/record locking should solve this problem. More info: http://msdn.microsoft.com/en-us/library/dbk0zee1(VS.80).aspx

How this is related to LIFO / FIFO? 

Answer 2

The question is, hw is the bill counter updated? Using an autoinc field you don't get double numbmers.

Bye, Olaf.

Answer 3

Hi Larry,

Welcome to the MSDN Forum.

According to your description, it seems that it is the same issue with the Multi-User updating without incrementing bill# by 1, please see my suggestion in the other thread.

Thank you for your understanding and support.

Best regards,

---

Mike Feng [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.