Multi users editing a database

[atimo]

I am developing a system in which there will be several users accessing and editing records in a SQL database.

I want to study more about the solutions for the integrity of the information, and I don't know where to start.

My concern now is about the situation where 2 or more users might be editing the same record at the same time.

Where and how should I lock that record? In the ASP code or in the database?

What if the user who has the record locked for his/her edition, all of a sudden turns the computer off without submiting the transaction?

Could you point the direction where I should look for more information?

Thanks

[mendhak]

Originally posted by atimo


Where and how should I lock that record? In the ASP code or in the database?

You would lock the record in the ASP code itself. You have about 4 lock options, read this page for the specifics.

What if the user who has the record locked for his/her edition, all of a sudden turns the computer off without submiting the transaction?

Eventually, it will time out and the records will be free again.

[blackeyed]

do one thing i know a person who can solve your troubles so mail him:-

meet_coolguy@yahoo.com

[blackeyed]

sorry man this message was meant for mendhak not for you.

Avi

[mendhak]

LoL...

But I doubt you could help me with astronuclear physical cosmological neutrino based reactions.