Microsoft Access Projects with Microsoft SQL Server

Natasha Nicols Dr, Ralf Albrecht, Dr Natasha Nicol9780735610026, 0735610029

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.