JET Database

From Wikibooks, the open-content textbooks collection

[edit] Synopsis

The Microsoft JET Database Engine, or simply JET, is a database engine distributed widely by Microsoft but 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 SQL.

[edit] Contents

[edit] Introduction

• What is JET?
• Reasons for not using JET
• Why this book is still needed
• Alternatives

[edit] Creating and connecting

• Creating a JET database
• Compacting a JET database
• Connecting to a JET database
• DAO vs SQL

[edit] Data types

• Text types
• Numeric types
• Boolean (Yes/No)
• Dates and times
• Counters
• BLOBs

[edit] Object names and constants

• Naming objects in the database
• Qualifying special names
• Constants
• Reserved words

[edit] Data integrity

• Constraints
• Transactions
• Locking

[edit] Security

• Database password
• Users, groups, permissions
• Encryption

[edit] Data definition language

• Creating and dropping tables
• Constraints
• Indexing
• Security

[edit] Updates and queries

• Select
• Insert
• Update
• Delete

[edit] Functions

• Scalar functions
• Aggregate functions

[edit] Views and stored procedures

• Views
• Stored procedures
• Alternatives

[edit] Manipulation tools

• Access
• Visual Studio
• JetSQLConsole
• PlaneDisaster.NET

[edit] Integration and migration

• Exporting to files
• Microsoft DTS and SSIS
• JET replication

[edit] Design tools

• Managing JET using Microsoft Visio

[edit] Index

• Index to statements, functions, data types

[edit] Contributors

• Contributors to this book

Wikibook Development Stages
Sparse text	Developing text	Maturing text	Developed text	Comprehensive text:

[edit] External links

Wikipedia has related information at Microsoft Jet Database Engine

• Microsoft Jet Database Engine 2.0: A User's Overview, MSDN library on-line
• Fundamental Microsoft Jet SQL for Access 2000, MSDN library on-line
• Intermediate Microsoft Jet SQL for Access 2000, MSDN library on-line
• Advanced Microsoft Jet SQL for Access 2000, MSDN library on-line
• Description of the new features that are included in Microsoft Jet 4.0, Microsoft knowledge base