JET Database
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
Introduction
- What is JET?
- Reasons for not using JET
- Why this book is still needed
- Alternatives
Creating and connecting
- Creating a JET database
- Compacting a JET database
- Connecting to a JET database
- DAO vs SQL
Data types
- Text types
- Numeric types
- Boolean (Yes/No)
- Dates and times
- Counters
- BLOBs
Object names and constants
- Naming objects in the database
- Qualifying special names
- Constants
- Reserved words
Data integrity
- Constraints
- Transactions
- Locking
Security
- Database password
- Users, groups, permissions
- Encryption
Data definition language
- Creating and dropping tables
- Constraints
- Indexing
- Security
Updates and queries
Functions
- Scalar functions
- Aggregate functions
Views and stored procedures
- Views
- Stored procedures
- Alternatives
Manipulation tools
- 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
External links
- Microsoft Jet Database Engine 2.0: A User's Overview, MSDN library on-line, via the Wayback Machine
- 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
- How to configure Jet 4.0 to prevent unsafe functions from running in Access 2000 and Access 2002, Microsoft knowledge base
- Access function reference