Update the same table from different applications

[Taleb Elm]

I have two separate applications who will access the same table in a database and the two application will update the table.
How can I make sure the integrity of accessing this table? Is it in the code or in the database level?

[Roger Sterling]

Database. http://en.wikipedia.org/wiki/Record_locking

[Taleb Elm]

thanks for the fast comment. Does it mean I have to communicate with database admin and no need to change any code in the applications?

[Roger Sterling]

Taleb Elm wrote:thanks for the fast comment. Does it mean I have to communicate with database admin and no need to change any code in the applications?

No, most databases have this feature built-in. Oracle, DB2, SQLServer, et al.