Jump to content

JET Database

25% developed
From Wikibooks, open books for an open world

The Microsoft JET Database Engine, or simply JET, is a database engine that was distributed widely by Microsoft but is now deprecated. As such, finding information on programming JET databases is becoming more and more difficult. This book attempts to remedy that by presenting necessary information about JET for programmers and database administrators.

This book assumes that the reader already has familiarity with SQL and requires a reference specifically for the JET database engine. Readers unfamiliar with SQL should first refer to the more generic database book Structured Query Language.

Contents

  • What is JET?
  • Reasons for not using JET
  • Why this book is still needed
  • Alternatives
  • Creating a JET database
  • Compacting a JET database
  • Connecting to a JET database
  • DAO vs SQL
  • Text types
  • Numeric types
  • Boolean (Yes/No)
  • Dates and times
  • Counters
  • BLOBs
  • Naming objects in the database
  • Qualifying special names
  • Constants
  • Reserved words
  • Constraints
  • Transactions
  • Locking
  • Database password
  • Users, groups, permissions
  • Encryption
  • Creating and dropping tables
  • Constraints
  • Indexing
  • Security

Updates and queries

  • Scalar functions
  • Aggregate functions
  • Views
  • Stored procedures
  • Alternatives
  • Access
  • Visual Studio
  • JetSQLConsole
  • PlaneDisaster.NET
  • CUTE
  • MDB Tools
  • Exporting to files
  • Microsoft DTS and SSIS
  • JET replication
  • Managing JET using Microsoft Visio
  • Index to statements, functions, data types
  • Contributors to this book
Wikibook Development Stages
Sparse text 0% Developing text 25% Maturing text 50% Developed text 75% Comprehensive text 100%