I am updating records with multiple differnt users. I want to use adLockOptimistic to ensure that updates are not overwritten. However in the event that someone tries to update a record once it has been updated by another user I need to redirect them to a different form. What success code is returned when SQL executes (or Not). What is the call for it. (i.e. eof or bof is not true than response.redirect "X.asp")