Microsoft Access Projects with Microsoft SQL Server

Here's the expert, hands-on guidance that professional Access programmers need to fully exploit the world-class scalability and knowledge-management capabilities in SQL Server 2000. This authoritative guide focuses on understanding and using the innovative Microsoft Data Engine (MSDE) technology that serves as the powerful core of SQL Server 2000. Readers are taken inside its high-performance data-management and data-replication features, developers dive into a whole new subset of Access technologies, known as Access projects, that they must learn in order to effectively program for SQL Server 2000. Topics include the Access project interface, specification table techniques, data types and constraints, and forms techniques. The book digs into stored procedures-a subject that's new to most Access developers-in depth and covers ASP and security issues as well. Throughout, the emphasis is on applying the reader's expertise building desktop database tools to accessing the enterprise-level power and performance in SQL Server 2000. The CD-ROM features all the book's sample applications, as well as a complete electronic version of the text for fast searches and reference.

User review
The best you can get in year 2003
Very good buy. Discuss a lot on the newest access technology like xml and web. However, there are some part of the example program missing in the CD provided, not a big issue as they can be easily written if you hav done some access form programming.

User review
Fast results
I love this book. I build a complex ADP application with a lot of SQL Server stored procedures. The authors described very good the differences between standard Access and ADP applications. They use a nice example (movie theater) to describe working with forms und reports in ADPs.

User review
Great help
This book was a great help! We successful create a ADP-application with Office XP and SQL Server 2000.

User review
Good bargain
We upsized our Access-MDB-application to SQL Server 7.0 with the help of this book. We are newbies to SQL Server and that is were the book starts. We now plan to move to Acc2K und SQL Server 2000.

User review
From A Devlelper
Dont waste your money. I got this today in the post. After a quick look when they install of all things SQL Server 7, I looked at the rest of the book. A new book which is available and written WHEN A2002 and SQL Server 2000 where available and this is the result. Save your money and download books online or buy SQL Access to SQL Server published by Apress. In one section that book has more useful information that this entire volume. MS Press seem to be throwing a book at everything lately and quality was bound to suffer. Pity it was an important area like ADPs that suffered. Me, I am returning this for a refund tomorrow. More useful information on MSDN.