Professional SQL Server Development with Access 2000 / Edition 1

Overview

What does this book cover? Full coverage of the use of Access 2000 projects with MSDE and SQL Server 7.0 Introduces the use of Access 2000 with SQL Server 2000 Programmatic database manipulation and querying using SQL, VBA, and ADO Database management with SQL-DMO Developing and using stored procedures Publishing data to the Web statically and dynamically using HTML and ASP Data Access Pages SQL Server security Upsizing Access databases Book overview Access 2000 is the latest version of a product that has a proven record in providing powerful, cost effective, and convenient database solutions for small and medium businesses. Through the feature of Access projects, and the introduction of the Microsoft Data Engine (MSDE), Access 2000 now offers a way for Access developers to harness the power of the SQL Server range of database engines while working inside a familiar framework. This book concentrates on the use of Access 2000 projects with MSDE and SQL Server engines and will highlight the ease with which sophisticated, scalable database solutions may be constructed. Since the delivery of data over the Internet is becoming crucial, this book will also cover the approaches and technologies required to build database-driven Web pages. Who is this book for? This book is primarily aimed at the intermediate to advanced Access developer, with a grasp of VBA and SQL, seeking to exploit Access 2000 project functionality to migrate from the Jet engine and build MSDE or SQL Server based solutions within an Access environment. SQL developers may benefit from the treatment of the Access interface if they wish to leverage the rapid application development tools of Access 2000 for increasing the accessibility of their database.

Read More