AshikHusein
Registered User.
- Local time
- Today, 15:29
- Joined
- Feb 7, 2003
- Messages
- 147
Hello all!
I have implemented this multi user ACCESS project where users access different records on the click of a button on a form. To prevent one users going on to the same client record there is a field called "Dummy1" in the backend table which keeps on getting updated to 1 as soon as any one user goes on to a particular record. As soon as the user goes to the next record, "Dummy1" gets updated to Null. "Dummy1" was set as an integer in the table design.
All was working well till yesterday when users started getting started seeing #Deleted in all the fields on the forms used for entering data and then other users started getting errors and the freezing problems.
When I started to pull up the reports, I realized to my horror that records were getting deleted!
And all I had done differently that day was that in the morning I changed the Default Value of the "Dummy1" field in the table design from 0 to Null so that it would be consistent with what it gets updated to if a user leaves the record and moves on to the next one.
Could this have created the automatic deletion problem?
Also, I had not set the Allow Delete on the form to "no" so could a user have inadvertently marked some records for deletion after using the "Mouse Wheel" (which is also painful to disable!)
I would appreciate an urgent insight into this since I can now feel the managements HOT BREATH being breathed down my back. Thank you.
I have implemented this multi user ACCESS project where users access different records on the click of a button on a form. To prevent one users going on to the same client record there is a field called "Dummy1" in the backend table which keeps on getting updated to 1 as soon as any one user goes on to a particular record. As soon as the user goes to the next record, "Dummy1" gets updated to Null. "Dummy1" was set as an integer in the table design.
All was working well till yesterday when users started getting started seeing #Deleted in all the fields on the forms used for entering data and then other users started getting errors and the freezing problems.
When I started to pull up the reports, I realized to my horror that records were getting deleted!
And all I had done differently that day was that in the morning I changed the Default Value of the "Dummy1" field in the table design from 0 to Null so that it would be consistent with what it gets updated to if a user leaves the record and moves on to the next one.
Could this have created the automatic deletion problem?
Also, I had not set the Allow Delete on the form to "no" so could a user have inadvertently marked some records for deletion after using the "Mouse Wheel" (which is also painful to disable!)
I would appreciate an urgent insight into this since I can now feel the managements HOT BREATH being breathed down my back. Thank you.
