JET Database

Category:Books with print version#JET%20Database

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

Introduction100% developed  as of 2007-04-23

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

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

Data types100% developed  as of 2007-04-23

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

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

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

Data integrity100% developed  as of 2007-04-23

  • Constraints
  • Transactions
  • Locking

Security

  • Database password
  • Users, groups, permissions
  • Encryption

Data definition language75% developed  as of 2007-04-23

  • Creating and dropping tables
  • Constraints
  • Indexing
  • Security

Updates and queries

Functions

  • Scalar functions
  • Aggregate functions

Views and stored procedures

  • Views
  • Stored procedures
  • Alternatives

Manipulation tools100% developed  as of 2011-04-26

  • Access
  • Visual Studio
  • JetSQLConsole
  • PlaneDisaster.NET
  • CUTE
  • MDB Tools

Integration and migration

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

Design tools

  • Managing JET using Microsoft Visio

Index

  • Index to statements, functions, data types

Contributors

  • Contributors to this book
Wikibook Development Stages
Sparse text 0% Developing text 25% Maturing text 50% Developed text 75% Comprehensive text 100%
Category:Book:JET Database#%20 Category:Subject:Database management systems#JET%20Database Category:Subject:Database management systems/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Books by subject/all books Category:Book:JET Database#%20 Category:Book:Wikibooks Stacks/Books#JET%20DatabaseCategory:Shelf:Database management systems Category:Shelf:Database management systems/all books Category:Shelf:Computer software/all books#Computer%20software Category:Department:Computing/all books#Computing Category:Alphabetical/J Category:Partly developed booksCategory:Books by completion status/all books
Category:Alphabetical/J Category:Book:JET Database Category:Book:Wikibooks Stacks/Books Category:Books by completion status/all books Category:Books with print version Category:Department:Computing/all books Category:Partly developed books Category:Shelf:Computer software/all books Category:Shelf:Database management systems Category:Shelf:Database management systems/all books Category:Subject:Books by subject/all books Category:Subject:Computer software/all books Category:Subject:Computing/all books Category:Subject:Database management systems Category:Subject:Database management systems/all books