How important is understanding database programming in Visual Basic you ask? Well, the overwhelming majority of all applications written in Visual Basic are database applications.
"Beginning Visual Basic 6 Database Programming" by Wrox Press is the best choice if you're a beginner to Visual Basic database programming. The book provides very clear and concise coverage of all aspects of VB database programming, such as, database design theory, DAO, the new Microsoft database access technology ADO, internet technology ASP, and much more. All the code examples in the book help provide the reader with a solid understanding of all of the topics being covered.
This book is definately worth reading if you're a newcomer to VB database programming.
If you have already read a beginner Visual Basic 6 database programming book or have some background in VB6 database programming, then "Professional Visual Basic 6 Databases" is an excellent next step. This book is the most popular and most highly renowned advanced VB6 database book presently on the market. It may be the only VB6 database book which has a 5/5 star rating by readers/reviewers at Amazon.com.
The book does an excellent job in covering the three-tiered architechture, Structured Query Language (SQL), data warehousing, ADO, MTS, and SQL Server 6.5/7.0. The author explains how to build a state of the art three-tiered application using ADO, MTS, and AQL Server. The end of the book provides an example which shows how to build an e-commerce shopping cart.
This book is a must if you're looking to bring your VB6 database knowledge to new levels!