>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.

It is a bad idea to put this in the Change event. Every character pressed make the recordset to be rebuild!

Since you ask to enter a date, you should refresh your recordset only on the lost focus or when you know that the date is complete!

From what I see, you are using DAO. If you switch to ADO, you have the Filter method that doesn't need to get back to the database to filter the currently open recordset!