I wrote my first full VB6 program that is pulling reports from an Access database. I have one connection (ado), and several recordsets that I am using. I have made sure to close each recordset and set it to Nothing at the end of each sub or function that uses it. Is there anything else I can do to speed the program up?
1. The user makes selections from a vb form.
2. These selections help determine the recordset (via an sql statement) that is passed to Crystal Reports 7.
Would appreciate any suggestions, or let me know if you need more details. I am mainly looking for general efficiency things to look for!
