In Access 2000, Microsoft's made it possible for Microsoft Access developers to leverage SQL Server as their native database engine while still using Access's familiar application design environment, giving their desktop database applications a solid migration path and unprecedented scalability. When it's time for you to take advantage of all that power, here's the book to buy: Microsoft Access Developer's Guide to SQL Server.
Mary Chipman and Andy Baron recognize that Microsoft's tools for upsizing tables are just the beginning. "The techniques and strategies that work well for building Access/Jet applications could indeed get you into trouble as you move to building SQL Server applications.... You need to upsize the entire application by rethinking its basic data-access architecture, and no wizard can do that for you."
They begin by introducing SQL Server 2000 from the perspective of the Access developer. You'll review your options for upsizing Access applications, understand new (and potentially confusing) SQL Server 2000 features, and master SQL Server 2000 security. (If you don't, the authors stress, it'll trip you up at every turn.) Should you use Microsoft Access's new ADP format or keep your front-end Access objects in MDB files? How can you link your existing Access database to SQL Server tables? Should you move from DAO to ADO, and if so, how?
You'll find start-to-finish coverage of SQL Server 2000 application design -- setting defaults, working with constraints, rules, triggers, and indexes. Chipman and Baron show you how to create and optimize views in SQL Server 2000; how to program effective stored procedures; and how to build unbound applications that can deliver far greater scalability. (Bill Camarda)
Bill Camarda is a consultant and writer with nearly 20 years' experience in helping technology companies deploy and market advanced software, computing, and networking products and services. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.