Microsoft Access Projects with Microsoft SQL Server

Microsoft Access Projects with Microsoft SQL Server, 9780735610026 (0735610029), Microsoft Press, 2002

The definitive guide to building enterprise solutions with Access Projects and SQL Server

Professional developers who use Microsoft® Access, the popular desktop database program, often confront limits to working with large amounts of data. This hands-on guide demonstrates in detail how to build powerful database solutions of unlimited size by retaining the familiar development environments of Access 2000 and Access 2002 while exploiting the enterprise-level power and performance of SQL Server™ 7.0 and SQL Server 2000. Find out how to use MSDE—the SQL Server version included with Microsoft Office Developer and Microsoft Visual Studio®—to store data on a SQL Server. Then learn how to create and use Access Projects, complete with queries, forms, reports, macros, and modules, to access SQL Server and MSDE databases. Topics covered include:

• Access Projects, database versions and installation, tables in Access Projects, database diagrams, views, stored procedures, and Transact-SQL
• Forms and reports
• Programming with ADO, connection objects, Recordset objects, Command and Parameter objects, and ADO events
• Using the Upsizing Assistant, and moving from DAO to ADO
• SQL Server and MSDE database administration, SQL Server tools, security, backup and recovery, data transformation services, SQL-DMO-Library, external data sources, and system procedures
• Multi-user transactions and locking
• Web publishing with the SQL Server Web Assistant Wizard, using XML with Access 2002 and SQL Server 2000

Comments

Amazing Books

An Introduction to Cyber Modeling and Simulation (Wiley Series in Modeling and Simulation)

John Wiley & Sons, 2018

Introduces readers to the field of cyber modeling and simulation and examines current developments in the US and internationally

This book provides an overview of cyber modeling and simulation (M&S) developments. Using scenarios, courses of action (COAs), and current M&S and simulation environments,...

Windows 7 100 Most Asked Questions - Tips, Tricks, Hints and Practical Guide

Emereo Pty Ltd, 2009

Is Windows 7 the answer to all the questions that Windows Vista poses? Windows 7 is fast, stable and far more reliable than you'd expect.

Windows 7 is full of great new features and enhancements and was built around users feedback, so you'll see a lot of things you've asked for.

Microsoft has made its...

Salivary Gland Disorders

Springer, 2007

Co-edited by Eugene N. Myers, a world-famous expert in the field, this has got to be the last word on salivary gland disorders. The disorders themselves cover a broad array of diseases, both benign and malignant. Thus, the contents of this book have been organized to reflect the diverse nature of salivary gland anatomy, physiology, and...

Hardcoregaming101.net Presents: The Guide to Classic Graphic Adventures

CreateSpace Independent Publishing Platform, 2011

In 1984, Roberta Williams of Sierra On-Line designed King's Quest, the world's first graphic adventure. A huge step beyond the text-oriented games that preceded it, the genre took the world by storm, and proved immensely popular with computers over the next decade. A combination of storytelling and puzzle solving, they provided the...

Definitive Guide to Excel VBA, Second Edition

Apress, 2003

Microsoft's Excel is not only a powerful spreadsheet and graphics tool—it contains a programming language called Visual Basic for Applications (VBA), which allows you to automate simple tasks and enables you to create full-featured applications that make Excel users even more productive. In the Definitive Guide to Excel VBA, Second...

Unconstrained Face Recognition (International Series on Biometrics)

Springer, 2005

Face recognition has been actively studied over the past decade and continues to be a big research challenge. Just recently, researchers have begun to investigate face recognition under unconstrained conditions. Unconstrained Face Recognition provides a comprehensive review of this biometric, especially face recognition from video, assembling a...