Microsoft Access Projects with Microsoft SQL Server

Publisher Microsoft Press
Author(s) Dr. Natasha Nicol
ISBN 0735610029
Release Date 16 January 2002

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.