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.