Synopses & Reviews
MSDE Developer's Guide 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 to SQL Server
- Build custom 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 the 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
Bonus CD-ROM Includes
- Sample databases and example code
- Demo programs, including Ultra-Edit, Rapid SQL, ER/Studio, and more
System Requirements PC running Windows 95 or later, Windows NT 4 or later. See the "What's on the CD-ROM" Appendix for further requirements and details. www.mandtbooks.com
Synopsis
This guide provides Access developers with a comprehensive overview of the Microsoft Data Engine. The book focuses on SQL implementation since many Access users rely on the Query By Example (QBE) functionality of Access. It includes coverage of how MSDE relates to VBA code, what special functionality is available through the Data Provider, and how MSDE deploys in an Access solution.
Synopsis
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 challengesUse Access wizards with MSDEPort MSDE applications using VBAGet expert advice for tuning your databaseExamine and manage transaction logsProtect your data with MSDE security featuresMaster data backup and recoveryLearn to use new Access Data Project in Access 2000Upsize existing Access databases to MSDEUse the SQL-DMO objects to control and manage MSDE or SQL ServerImport and export almost any data type with the Data Transformation Services
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.