Pessimistic Locks in SQL 2005

[Hellgofi]

I am used to use Access as a mdb files but now I am giving a serious try to Access projects (adp).

If it was not adp setting default lock rule for the database would be quite easy but I couldnt find an easy way to do that in Sql 2005. I read something about transactional isolation levels but confused a little bit (cause I need to know more about SQL server)

is there any setting that can be done easily on the Sql side to switch default lock setting from optimistic to pessimistic?


thanks