JET Database

From Wikibooks, the open-content textbooks collection

Jump to: navigation, search

[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

Contents

[edit] Introduction100% developed  as of 2007-04-23

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

[edit] Creating and connecting75% developed  as of 2007-04-23

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

[edit] Data types100% developed  as of 2007-04-23

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

[edit] Object names and constants100% developed  as of 2007-04-23

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

[edit] Data integrity100% developed  as of 2007-04-23

  • Constraints
  • Transactions
  • Locking

[edit] Security

  • Database password
  • Users, groups, permissions
  • Encryption

[edit] Data definition language75% developed  as of 2007-04-23

  • Creating and dropping tables
  • Constraints
  • Indexing
  • Security

[edit] Updates and queries

[edit] Functions

  • Scalar functions
  • Aggregate functions

[edit] Views and stored procedures

  • Views
  • Stored procedures
  • Alternatives

[edit] Manipulation tools100% developed  as of 2007-07-27

  • 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 00%.svg Developing text 25%.svg Maturing text 50%.svg Developed text 75%.svg Comprehensive text: 100%.svg


[edit] External links

Wikipedia-logo.png

Wikipedia has related information at
Microsoft Jet Database Engine
Retrieved from "http://en.wikibooks.org/wiki/JET_Database"