MSDE Developer's Guide

MSDE Developer's Guide

by Dan Rahmel

Paperback(BK&CD-ROM)

$33.41 $39.99 Save 16% Current price is $33.41, Original price is $39.99. You Save 16%.

Temporarily Out of Stock Online

Eligible for FREE SHIPPING

Overview

MSDE Developer's Guide by Dan Rahmel

Discover how to use MSDE effectively in your Access 2000 development

As a database developer, you'll find this complete guide invaluable if you want to harness the power of this Access 2000 back-end option, which is fully scalable to Microsoft SQL Server.

Inside, you'll find expert advice on using MSDE to create a wide range of database applications, plus thorough explanations on advanced topics, such as creating stored procedures and implementing data replication. It's all here — from migrating your existing applications to MSDE to implementing remote data services and Web access.

Working solutions for MSDE challenges

  • Use Access wizards with MSDE
  • Port MSDE applications using VBA
  • Get expert advice for tuning your database
  • Examine and manage transaction logs
  • Protect your data with MSDE security features
  • Master data backup and recovery
  • Learn to use new Access Data Project in Access 2000
  • Upsize existing Access databases to MSDE
  • Use the SQL-DMO objects to control and manage MSDE or SQL Server
  • Import and export almost any data type with the Data Transformation Services

Product Details

ISBN-13: 9780764546983
Publisher: Wiley
Publication date: 08/01/1900
Edition description: BK&CD-ROM
Pages: 561
Product dimensions: 7.60(w) x 9.26(h) x 1.37(d)

About the Author

Dan Rahmel is a cofounder and partner of Coherent Data, an independent consulting company specializing in information systems and Internet marketing. He has authored and coauthored many books, including Visual Basic 6 Programmer's Reference, and contributes regularly to magazines such as DBMS, Internet Advisor, and American Programmer.

Table of Contents

Preface.

Acknowledgments.

PART I: Access and MSDE.

Chapter 1: Concepts and Basics.

Chapter 2: Access 2000 and MSDE.

Chapter 3: The Access Wizards.

Chapter 4: Architectural Overview.

Chapter 5: The Basics of the SQL Language.

Chapter 6: Advanced SOL.

Chapter 7: Stored Procedures.

Chapter 8: Access Data Project (ADP).

Chapter 9: ADO Overview.

Chapter 10: VBA, MSDE, and Advanced ADO.

PART II: Using MSDE.

Chapter 11: Using the Enterprise Manager.

Chapter 12: Using the Database Designer.

Chapter 13: Using Data Transformation Services and.

Packages.

Chapter 14: Working with Views.

Chapter 15: Replicating Data.

Chapter 16: Using SQL-DMO.

Chapter 17: Creating User-Defined Data Types.

PART III: Advanced MSDE.

Chapter 18: Monitoring MSDE.

Chapter 19: Working with SQL Server Agent.

Chapter 20: Accessing the Web with Remote Data Services.

Chapter 21: Tuning for Optimum Performance.

Chapter 22: Working with MSDE Logs.

Chapter 23: Moving Data Into and Out of MSDE.

Chapter 24: Using Stored Procedures in MSDE.

Chapter 25: Implementing Security.

Appendix: What's on the CD-ROM.

Index.

End-User License Agreement.

CD-ROM Installation Instructions.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews