Hello,

This is my first post on here and am in need of some advice. I normally work with Oracle databases but have been asked to write a VB6/MS Access program.

Im using Visual Basic 6.0 Professional. Using Visual Data Manager v6.0. Im using data1.recordset usage to access the data. The only large table I have has 5000 records and it takes approximately 1 minute to load the initial window with all these records. I have tried to create indexes on the fields which I think will be in the "where" clause, as in Oracle, but response is still slow.

My question is, what am I doing wrong and how do I see the "pure SQL" like SELECT name FROM customer WHERE name="Hibbs", using VB so I can create the index accordingly?

Many Thanks.