Visual Basic Database Programming (With CD-ROM)

The expert guide to better database application development with Visual Basic.-- In-depth coverage of ADO, including a compact reference of ADO.-- Powerful optimization solutions -- and real-world workarounds for undocumented problems!-- Includes detailed coverage of SQL Server and Microsoft Data Engine (MSDE)According to Microsoft, two-thirds of all Visual Basic programmers develop database applications. In Visual Basic Database Programming, Michael Kofler targets VB database application development, showing experienced Visual Basic programmers exactly how to take full advantage of VB6 and SQL Server to build more robust, faster applications. Kofler begins with an introduction to the ADO (ActiveX Data Objects) database library, and to Microsoft's diverse Visual Basic database productivity tools, such as the DataEnvironment designer. Next, he introduces powerfully efficient programming techniques for accessing data stored on Microsoft SQL Server databases. Finally, the book includes a compact reference of ADO 2.1 objects and controls. All examples are based on SQL Server 7. Kofler offers detailed, hard-to-find information about the Microsoft Data Engine (MSDE), Microsoft's new, free database engine, showing how to use MSDE as a low-cost starting point for projects that can be scaled up to Microsoft SQL Server later, with no code changes. From start to finish, Visual Basic Database Programming identifies undocumented problems, presents workarounds, and describes optimizations based on how VB and SQL Server 7 really work together. The accompanying CD-ROM contains an extensive code library, a 100 MB test database, and a complete copy of the Microsoft Data Engine (MSDE).