Product Description

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.

Product Details

• Amazon Sales Rank: #339868 in Books
• Published on: 2000-12-20
• Original language: English
• Number of items: 1
• Binding: Paperback
• 864 pages

From the Back Cover

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.

About 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

Informative guide on how to combine Access and SQL Server
Having developed Access applications for a number of years, I was asked to create a system utlising SQL Server as the backend with a windows interface for the client. I knew Access was able to communicate with SQL server, but how that was achieved was unfamilar territory. The book guided me through the intracacies of the subject revealing the different mindset that was necessary to achieve the desired result. Loads of useful code examples, all downloadable from the web. One comment, the Index at the back wasn't comprehensive enough. However I read the book from cover to cover so was able to locate all the subjects I needed. Not recommended for those who are unfamilar with Access or database terminology.

A must for anyone upsizing from Access to SQL Server
This book contains many useful tips and covers everything about the move from Access 97/2000 to SQL Server 2000. It's very well written and explains everything clearly for the intermediate/expert user. The book has no CD with the source code, but all the code can be downloaded from the website. Definitely recommended!

Great book, Informative, well documented
I picked up this book and read through the chapters. I have Access 97/2000 developer experience albeit on a small scale. We need to move to SQL Server 2000 to cope with increases in Databases and Users. This book has enabled me to plan the transition and has pointed out most of the pitfalls, I would definitely have met.

Great for intermediates upward for whom upsizing to SQL if a concern.