February 17, 2012 at 11:18 am
Is it possible to clear a SQL table while other users are accessing it through Access?
February 17, 2012 at 11:33 am
Yes, but the transaction will have to wait its turn. Locks will have to be released by all other users. That's usually automatic, doesn't require any human intervention.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 17, 2012 at 1:25 pm
sumitagarwal781 (2/17/2012)
clearing in the sense what truncate or delete? and it wont allow to clear while other users are accessing the table simultaneously.
Sure it will. Unless someone is holding a lock permanently, which is unusual. It just takes its turn in the locking sequence, or gets killed by a deadlock, or whatever, just like any other transaction.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply