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 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
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.
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.
End-User License Agreement.
CD-ROM Installation Instructions.