Microsoft Jet Database Engine Programmer's Guide (Microsoft Professional Editions) (Paperback)

by Dan Haught (Author), Jim Ferguson (Author)

Editorial Reviews

Product Description
Complete guidance, including examples, for using the powerful database engine used in Microsoft Access, Microsoft Excel, Microsoft Visual Basic(r), Microsoft Visual C++(r), and Microsoft Office 97, Developer Edition. It shows how to reuse code in many products and how to combine products into custom database applications. The accompanying CD-ROM contains all of the book's code samples, useful tools, and utilities.

Product Details

• Paperback: 756 pages
• Publisher: Microsoft Press; 2nd edition (August 1997)
• Language: English
• ISBN-10: 1572313420
• ISBN-13: 978-1572313422
• Product Dimensions: 9 x 7.5 x 2.2 inches
• Shipping Weight: 3.6 pounds
• Average Customer Review: 4.7 out of 5 stars See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #784,436 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

5.0 out of 5 stars I wish I'd found this book sooner, October 11, 1998

By A Customer

By all rights, the information here should be inclued in the other VBA books, but it's not. After buying too many books on Access and VBA programming, I've finally found a resource that gives more than a cursory look at Microsoft Jet database and programming considerations. Maybe if you already know what you're doing and don't need the Jet shortcuts, bound objects, etc. this book is unnecessary, but if you want to do simple multi-user database applications, this book is essential. Clueless about locking in a multiuser environment and Jet vs. Direct ODBC access? This'll put you on the right track. Not a lot of programming examples, but those are easy to find elsewhere.

4 of 4 people found the following review helpful:

5.0 out of 5 stars This is a great book for Database Programmers, January 21, 2000

By	Jason Mauss (SF Bay Area, CA) - See all my reviews

Not only does this book go into great detail about how the whole Jet Database Engine works, it describes the whole structure of the Workspaces Data Access Object Model. The information in this book has helped me countless times when I've needed to get information about tables, queries, recordsets, fields to show to users. I was even able to create my own report wizard in VB, and it works just like the one in Access! This book will teach you TONS about the way the Jet Database engine works, and works great as a reference. If more programmers knew the information contained in this book, there wouldn't be as much confusion going on.

6 of 7 people found the following review helpful:

5.0 out of 5 stars The Bible for Manipulating the MS Database Engine, August 2, 2000

By	Conrad B. Senior (Easton, CT United States) - See all my reviews (REAL NAME)

The best computer book I've ever bought. If any book will make you feel like you have the power of God this is it. This book allows you directly access the Jet database engine and make it do whatever you want. If you are interested in getting really good with MS databases--this is the only enssential book to own. Master this book and you should command an annual salary of $150k or more.

The CD ROM includes code samples, white papers, and utilities associated with the book.

Index

1. An Overview of Microsoft Jet

2. Introducting Data Access Objects

3. Data Definition and Integrity

4. Queries

5. Working with Records and Fields

6. Creating Mulituser Applications

7. Database Replication

8. Accessing External Data

9. Developing Client/Server Applications

10 Managing Security

11. Programming with DAO in C++ and Java

12. ODBC Desktop Drivers

13. Optimizing Performance

Appendix A: Specifications

Appendix B: SQL Reference

Appendix C: Registry Settings

Appendix D: Error Reference

Appendix E: Microsoft Jet Components