I need to know how to lock a record in a database so two people can’t edit it at the same time, but they need to still be able to view it. I’ve thought about putting a field in the database that if they go to edit the record it puts a flag in it that I can then use to not allow others to edit it. That’s easy enough on the front end, but potentially problematic if the fields value doesn’t get cleared out after they’ve left the page or left the site. I know you can use the global.asa file to handle some of this, but I’ve never been able to get this to work 100%. It’s always been somewhat faulty. Does anyone have any ideas on the best way to handle this? Thanks!
Help @nbcrockett spread the word by sharing this article on Twitter...Tweet This