Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Now while the above code is running, the entire recordset is being locked, how can I make this read only?
Dim rsSchedules As New ADODB.Recordset rsSchedules.ActiveConnection = CurrentProject.Connection rsSchedules.Source = strSQL rsSchedules.Open Do Until rsSchedules.EOF 'My Code here.. Loop Set rsSchedules = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Convert results from the query output to insert into sql table||3||27|
|create different version if file exists||1||44|
|Delete duplicates from SQL Server table||2||24|
|Need split for SQL data||4||34|
Join the community of 500,000 technology professionals and ask your questions.