Table of Contents

Introduction 1

Part I: The Basics of Databases 9

Chapter 1: The Big Picture: Visual Basic’s Database Features 11

Chapter 2: Databases 101: How Databases Work 19

Part II: Making a Connection 35

Chapter 3: Getting Connected with Data Controls and the Data Form Wizard 37

Chapter 4: Using the Data Environment Designer 53

Chapter 5: A Collection of Connection 71

Part III: Contacting the User 87

Chapter 6: Reports-Plain and Fancy 89

Chapter 7: Designing a User Interface 107

Part IV: Building a New Database 123

Chapter 8: Creating and Manipulating a New Database 125

Chapter 9: Validating and Indexing Your Data 135

Chapter 10: Creating Custom, Data-Bound ActiveX UserControls 147

Part V: The Internet Connection 163

Chapter 11: Translating Windows Applications to Web Pages: Using the ActiveX Document Migration Wizard 165

Chapter 12: Mixing HTML and VB: Active Server Pages 183

Chapter 13: IIS Applications: Moving Beyond ASP 197

Part VI: Hands-On Programming 217

Chapter 14: Doing it Yourself: Data Access Programming 219

Chapter 15: Acronym Soup: ADO, DAO, RDO, UDA 257

Chapter 16: Focus on ADO 265

Chapter 17: Killing Bugs 287

Part VII: Working with Queries 303

Chapter 18: Automatic SQL: Using the Query Designer 305

Chapter 19: A Brief Dictionary of SQL 325

Part VIII: The Part of Tens 347

Chapter 20: Ten Outstanding Add-Ons 349

Chapter 21: Ten Topics that Don’t fit Elsewhere in the Book (But Are Important) 353

Index 363

Book Registration Information……Back of Book

About the Author

Richard Mansfield, the former editor of Compute! magazine, is the author of more than 20 computer book bestsellers, including Visual Studio 6 For Dummies and Visual InterDev Bible. Nickolas Landry, who supplied the technical review, is an MCSD and a Microsoft Regional Director.