Ships from: Naperville, IL
Usually ships in 1-2 business days
This is the official technical reference on Microsoft Jet, the powerful database engine used in Microsoft Access and Micosoft Visual Basic for Windows 95. If you write code that creates and manipulates a database in one of these products, you can easily use that same code in the other, or use both products together to create custom database applications. You'll learn what Jet is, how to use it, and how it compares to other database engines. Each chapter includes a simple Visual Basic program that is built upon to illustrate points throughout the discussion.
This is the official technical reference on Jet, the powerful database engine used in Microsoft Access and Visual Basic for Windows 95. The book starts by describing what Jet is, how to use it, and how it compares to other databases. Each chapter includes a simple Basic program that it builds upon within the chapter to illustrate points. CD includes the Jet Database Engine.
| Foreword | ||
| Acknowledgments | ||
| About the Authors | ||
| About the Technical Contributors | ||
| Preface | ||
| Ch. 1 | An Overview of Microsoft Jet | 1 |
| Ch. 2 | Introducing Data Access Objects | 19 |
| Ch. 3 | Data Definition and Integrity | 55 |
| Ch. 4 | Queries | 87 |
| Ch. 5 | Working with Records and Fields | 139 |
| Ch. 6 | Creating Multiuser Applications | 183 |
| Ch. 7 | Database Replication | 223 |
| Ch. 8 | Accessing External Data | 275 |
| Ch. 9 | Developing Client/Server Applications | 319 |
| Ch. 10 | Managing Security | 369 |
| Ch. 11 | DAO C++ Classes | 407 |
| Ch. 12 | ODBC Desktop Database Drivers | 437 |
| Ch. 13 | Performance | 463 |
| Appendix A Specifications | 485 | |
| Appendix B SQL Reference | 493 | |
| Appendix C Registry Settings | 507 | |
| Appendix D Error Reference | 529 | |
| Index | 553 |
Overview
This is the official technical reference on Microsoft Jet, the powerful database engine used in Microsoft Access and Micosoft Visual Basic for Windows 95. If you write code that creates and manipulates a database in one of these products, you can easily use that same code in the other, or use both products together to create custom database applications. You'll learn what Jet is, how to use it, and how it compares to other database engines. Each chapter includes a simple Visual Basic program that is built upon to...