Database Access with Visual Basic's major emphasis is on solutions, not technology. Rather than rattling off a list of features, diagrams and acronyms, this book provides step-by-step examples of the most important techniques developers typically go through to create database applications. Learn how to design a database, build the user interface, write queries, and construct a three-tiered client server system based on ADO 2.0, RDO, COM, SQL Server or Oracle. Find out "what's new?" in Visual Basic 6 as it applies to data access strategies. Receive more information on different types of SQL queries and differences between the Access and SQL Server dialects.
Table of Contents:
1. Database Basics
2. Queries
3. Data Access Objects
4. Reporting & Exploring Data
5. Getting Started with SQL Server
6. ODBC &RDO
7. Data Access With Classes
8. Remote Data Access
9. Multiplier Databases
10. ActiveX Data Objects
11. Internet Database Applications
12. User Interface Controls
13. Using the DB Grid & Apextrue DB Grid Control
14. Using the MS Flex Grid, Hierarchial Flex Grid & Videosoft VS Flex Controls
15. Using Sheridan Data Widgets