Hi there,<BR><BR>Do you need to lock the databse with a shared lock when retrieving information from the database? Also do you need to have an exclusive lock when updating or inserting into the database? At the moment I have neither, probably stupid hey?<BR><BR>Anyhow, if I dont have any locks, what happens if 2 or more people update or insert into the database at exactly the same time? Will there be inconsistencies or corrupt data? Or do the queries fall into some sort of a queue and are handled in a first in first out manner? Are locks really necessary? And if so when do I use shared locks and exclusive locks, what is the code for either in a dnsless connection?<BR><BR>Thanks for your time,<BR>Elad<BR>