Unanswered: Using a cn & Rs with out locking others out of the db
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
set cn= nothing
set rs= nothing
i dont know why anyone would be locked out. Any Ideas pls?