Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL coding problem
Message
From
23/07/2000 23:32:11
Victor Lapid
Phil. Long Distance Tel. Co.
Manila, Philippines
 
 
To
All
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Title:
SQL coding problem
Miscellaneous
Thread ID:
00396049
Message ID:
00396049
Views:
47
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
Map
View

Click here to load this message in the networking platform