General information
Category:
Coding, syntax & commands
Hi,
I have this code in the textbox change event tha refreshes a grid during runtime and I found out that it becomes very slow when already accessing 5000 records in an access
database.
Data1.RecordSource = "select * from activity where date like'*" & TxtDate.Text & "*'"
Data1.Refresh
Is the problem basically in the code or VB's jet engine or the access database itself?
TIA.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only