VB and Access Queries
Posted on 1999-07-20
Need help with the next problem:
I have got an Access (97) Database with one Table in it, the table contains about 1 to 2 million records.
In VB (5.0 with ADO 1.5) I am using ParameterQueries in the Database to return search results.
In of the ParmQueries I am using a 'Like' criteria (I need to be able to search for something like 'Name LIKE a*' or 'Town LIKE b*').
Beacuse the Database will be on CD eventually, I need to speed up performance BIGTIME (returning records with 'Name LIKE a*' takes about half a minute(:, the table has an index consisting of searched for 'Name' and 'Town')
If someone could make some suggestions for speeding up performance I would be very gratefull!!!!!!!