Environment Info:
- MS Access Sales System (front-end)
- SQL Server Standard (back-end)
Information of the Problem:
** In the Inventory items data:
- when user enters a new item and does not
encounter problems entering it, the subsequent changes to the item
information will not cause any problems
- when user enters a new item and encounters problems during the
entry stage, the subsequent changes to the newly entered data will
cause a "Drop Changes" error
To quick fix the situation of the problem, I had to help the user and make
changes to the item information directly at the back-end.
Does anyone have an idea where to start in fixing the problem?
Thanks!