• ▼MSDN Library Visual Studio 6.0
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio Documentation
  • ▶Visual Basic Documentation
  • ▶Visual C++ Documentation
  • ▶Visual FoxPro Documentation
  • ▶Visual InterDev Documentation
  • ▶Visual J++ Documentation
  • ▶Visual SourceSafe Documentation
  • ▶Tools and Technologies
  • ▶Microsoft Office Development
  • ▶Platform SDK
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Specifications
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▼Books
    • ▶Developing International Software for Windows 95 and Windows NT
    • ▶Advanced Microsoft Visual Basic 5
    • ▶Hardcore Visual Basic
    • ▶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
      • ▶Chapter 10 Managing Security
      • ▶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
          • ▶Configurable Performance Settings
          • ▶Key Internal Performance Enhancements
          • ▼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 97 Hardware Design Guide
    • ▶PC 98 System Design Guide
    • ▶Programming the Windows 95 User Interface
    • ▶Understanding Thin-Client/Server Computing
    • ▶The Windows Interface Guidelines for Software Design
  • ▶Partial Books
  • ▶Periodicals
  • ▶Conference Papers