jrich7970 Posted March 16, 2010 Share Posted March 16, 2010 Perhaps I'm reading about locks incorrectly, because it looks like they are at a record level. I'd like to lock a table for a time, then unlock it.My situation is that I'm doing a directory list, with files that are strictly named with a date in them. I would like to present them to the user in chronological order (no guarantee that the timestamp on them is correct).So, I'm reading them, extracting the date from the file name, and putting them into a table. Then I'll do a select, ordering by the date.Instead of just dropping the table, I'm just doing a delete * from mytable...Deal is, if TWO people are doing this at the same time, things could get messed up.How do I lock user 2 (or 3, etc) out, until user 1 is complete? Also, can I have user 2 wait until user 1 is complete, or do I just have user 2 error out? Would I set a nice long timeout?Thanks for your help.Oh, sorry, I'm using ASP and an MS Access database. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.