Microsoft Access Developer's Guide to SQL Server

Microsoft Access Developer's Guide to SQL Server

5.0 1
by Andy Baron, Mary Chipman
     
 

Microsoft Access 2000 Developer's Guide to Microsoft SQL Server provides much needed information and guidance for the Access power user or developer who wants to exploit the power of SQL Server. Written by Access experts and Microsoft MVPs Mary Chipman and Andy Baron, this hands-on guide provides you with the practical knowledge you need to harness the

Overview

Microsoft Access 2000 Developer's Guide to Microsoft SQL Server provides much needed information and guidance for the Access power user or developer who wants to exploit the power of SQL Server. Written by Access experts and Microsoft MVPs Mary Chipman and Andy Baron, this hands-on guide provides you with the practical knowledge you need to harness the enterprise-level power and scalability SQL Server offers, while using the Access tools you are familiar with. More than just a migration guide, you will benefit from the authors' expert discussions of topics including the new Microsoft Database Engine (MSDE), Transact SQL, building stored procedures and views, converting your applications to SQL Server, working with SQL Server security, and building Access interfaces to SQL Server databases.

Editorial Reviews

bn.com
The Barnes & Noble Review
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.

Product Details

ISBN-13:
9780672319440
Publisher:
Sams
Publication date:
12/13/2000
Series:
Sams White Book Series
Pages:
864
Product dimensions:
7.40(w) x 9.10(h) x 1.80(d)

Meet the Author

Mary Chipman and Andy Baron are senior consultants with MCW Technologies. They are contributing editors for the two leading Access journals, Smart Access and Access VB Office Advisor and speak regularly at industry conferences. In addition, they conduct training seminars for the Application Developers Training Company, and have been designated Access MVPs by Microsoft based on their contributions to Microsoft's online support. Lead Author Mary Chipman has co-authored two books on SQL Server--The Access and SQL Server Developers Handbook, and SQL Server 7 In Record Time.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Microsoft Access Developer's Guide to SQL Server 5 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
Here is the text of an e-mail I sent to one of the authors after getting this book: Dear Ms. Chipman, Bravo and a standing ovation to you and Andy Baron for 'Access Developers Guide to SQL Server'. This book is much more than the title implies. It should be required reading for all SQL Server developers regardless of the front end they use. I can't think of a better programming book in my vast collection. I'm learning alot from this and I've only been browsing through it. Beautifully written, too.