I was just informed that everyone was locked out of the db becuase i was running code. I think there are settings for the connection and recordset object that i can set to prevent this. My current RS & CN code is :

Set cn = Application.CurrentProject.Connection
Set RS = CreateObject("ADODB.Recordset")
RS.Open sqlCkDate, cn, 1 ' 1 = adOpenKeyset

....
....

cn.close
rs.close

set cn= nothing
set rs= nothing

i dont know why anyone would be locked out. Any Ideas pls?

M~