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
|Access Query based on a Form Field||2||18|
|ms/access webbrowser address not valid -||12||32|
|sql query questions||2||21|
|Is it possible to replace huge Multiple Spaces with a single space in SQL Server||2||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!