I have several tables set up in my database, and I want to be able to lock the record once it is entered. My users keep complaining that data is disappearing, but I think theyre just incompetent and are accidently deleting the data. If anyone has an answer or a tip, I would be appreciate it very much. Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
locking records once they are entered
- Thread starter cdthomas9
- Start date
sleipnir214
Programmer
To the best of my knowledge, there is no feature built into MySQL to do what you want.
One solution is to add a column to the table in question, and have any application which will delete from the table delete only those rows where that column is set to 0.
Want the best answers? Ask the best questions: TANSTAAFL!
One solution is to add a column to the table in question, and have any application which will delete from the table delete only those rows where that column is set to 0.
Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #3
sleipnir214
Programmer
I understand your problem. I was unclear in my first answer -- let me try again.
There is no mechanism in MySQL whereby a record can be locked so that no mechanism, prior to unlocking the record, can prevent deletion of that record.
It sounds to me that whatever application your users are using to manipulate the data, that application has no mechanism within it to perform these locks, either. Or if it does, that mechanism is not functional.
You might be able to modify your tables by adding a column named "can_delete", which has a default value of 1. If you need to protect a row, change the value in that row's "can_delete" record to 0. Then modify the application so that it will not delete a row, the "can_delete" column of which is 0.
Want the best answers? Ask the best questions: TANSTAAFL!
There is no mechanism in MySQL whereby a record can be locked so that no mechanism, prior to unlocking the record, can prevent deletion of that record.
It sounds to me that whatever application your users are using to manipulate the data, that application has no mechanism within it to perform these locks, either. Or if it does, that mechanism is not functional.
You might be able to modify your tables by adding a column named "can_delete", which has a default value of 1. If you need to protect a row, change the value in that row's "can_delete" record to 0. Then modify the application so that it will not delete a row, the "can_delete" column of which is 0.
Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #5
sleipnir214
Programmer
There should be -- but the exact method I do not know.
If you are using Access in its standard form (no VB or VBA application running) probably not.
If you are running a VB or VBA application within Access, then that application could be modified to not delete records that are flagged.
Want the best answers? Ask the best questions: TANSTAAFL!
If you are using Access in its standard form (no VB or VBA application running) probably not.
If you are running a VB or VBA application within Access, then that application could be modified to not delete records that are flagged.
Want the best answers? Ask the best questions: TANSTAAFL!
- Status
Similar threads
- Locked
- Question
- Locked
- Question