A reply on so many data and SQL questions, this attachment has 20 forms with all different connection samples and data related queries. This will put any beginner on the right track to successful coding in vb6. I have put together this sample from numerous others over the past few years. Thank you to all other people who posted their code in so many other forums, you are all part of this sample.
How to start and run samples:
In your design area, click on "Project" and then "Properties". Select the page you want to view and click "Run" or F5.
If this helped you towards connecting your data and application, vote for me - http://www.daniweb.com/forums/member256591.html - AndreRet