• ▼MSDN Library - April 2000
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio 6.0 Documentation
  • ▶Office Developer Documentation
  • ▶Windows CE Documentation
  • ▶Platform SDK
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▶Specifications
  • ▼Books
    • About Books
    • ▶Advanced Microsoft Visual Basic 5
    • ▶Developing International Software for Windows 95 and Windows NT
    • ▶Hardcore Visual Basic
    • ▶Hardware Design Guide Version 2.0 for Microsoft Windows NT Server
    • ▶Inside OLE
    • ▼Microsoft Jet Database Engine Programmer's Guide
      • Foreword
      • Acknowledgments
      • ▶Preface
      • ▶Chapter 1 An Overview of Microsoft Jet
      • ▶Chapter 2 Introducing Data Access Objects
      • ▶Chapter 3 Data Definition and Integrity
      • ▶Chapter 4 Queries
      • ▶Chapter 5 Working with Records and Fields
      • ▶Chapter 6 Creating Multiuser Applications
      • ▶Chapter 7 Database Replication
      • ▶Chapter 8 Accessing External Data
      • ▶Chapter 9 Developing Client/Server Applications
      • ▶The Object Model for ODBCDirect Workspaces
      • ▶Chapter 11 Programming with DAO in C++ and Java
      • ▶Chapter 12 ODBC Desktop Database Drivers
      • ▼Chapter 13 Optimizing Performance
        • Configuration Using the Registry
        • Repairing Databases
        • ▶Compacting Databases
        • ▶Performance Enhancements in Microsoft Jet 3.5
        • ▼Other Optimization Tips and Techniques
          • Using DBEngine(0)(0) Instead of CurrentDb
          • Prevent Unnecessary Query Recompilation
          • Avoid Embedding Expressions in Queries
          • Use Indexes Cautiously
          • Use SQL DDL Statements Instead of DAO Looping Routines
          • Implement Persistent Connections with Linked Tables
          • Use Explicit Transactions When Implementing OLTP
          • Check Parameter Queries for Optimal Performance
        • ▶Unsupported Tuning Functions
      • ▶Appendix A Specifications
      • Appendix B SQL Reference
      • ▶Appendix C Registry Settings
      • Appendix D Error Reference
      • ▶Appendix E Microsoft Jet Components
    • PC 99 System Design Guide
    • ▶Programming the Windows 95 User Interface
    • ▶Understanding Thin-Client/Server Computing
    • ▶The Windows User Experience
  • ▶Partial Books
  • ▶Periodicals
  • ▶Samples