Thursday, May 05, 2011 9:23 PMI 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.
Thursday, May 05, 2011 11:41 PMModerator
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?
Friday, May 06, 2011 9:22 AM
The question is, hw is the bill counter updated? Using an autoinc field you don't get double numbmers.
Tuesday, May 10, 2011 4:48 AMModerator
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.
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.
- Marked As Answer by Larry_Nuñez Wednesday, May 11, 2011 1:09 PM