[书籍-ADP专著]Microsoft Access Projects With Microsoft SQL Server

zhuyiwen

Microsoft Access Projects With Microsoft SQL Server

这本书专讲ADP，不讲 ODBC 的 mdb，是 Microsoft 出版的 ADP 专著。



Introduction to Microsoft SQL Server and Access

Microsoft Access is the most commonly used product for desktop databases among beginners and professionals alike. However, Access has limitations when it comes to the administration of large amounts of data that many users access through a network.

Microsoft positions Microsoft SQL Server as a database server that can make large amounts of data available to many users at the same time. In addition, a SQL Server version is included with Microsoft Office Developer suites and Microsoft Visual Studio as a Microsoft Data Engine (MSDE) with limited functionality.

One goal of this book is to describe how Access and SQL Server or MSDE work together. Since the release of Microsoft Access 2000, it is possible to create Access projects. Access projects provide users and programmers with the usual Access development environment that includes queries, forms, reports, macros, and modules, with the data being saved on a SQL Server. Because this book focuses on creating Access projects (adp) and describing its new options and functions, the book does not cover the options of accessing SQL Server tables using Open Database Connectivity (ODBC) and so on using regular Access databases in .mdb format.

Access is a comfortable, high-performance development environment for the implementation of user-friendly applications. The second goal of this book is to demonstrate how you can retain Access as a development environment while using a high-performance server database at the same time. Access is often ridiculed as a “toy,” with its usefulness limited to the implementation of a few small applications on desktop systems. However, by now, many Access programmers have proven the program’s capability for handling medium-sized and large applications.

This book is based on working with software projects that utilized Access projects and SQL Server to replace existing Access solutions and original project developments that took advantage of SQL Server’s performance features. Several version changes occurred while this book was being written: Microsoft SQL Server 2000 is the successor of Microsoft SQL 7, and Microsoft Access 2002 as part of Microsoft Office XP is the successor of Access 2000. SQL Server 2000 and Access 2002 feature a large number of improvements, particularly for tasks that require programming with Access projects. We have incorporated information about both new versions in the book and we discuss the problems related to version incompatibilities. For example, some Access 2000 project functions do not work while accessing SQL Server 2000.

yyb7858

tmtony 发表于 2011-8-4 18:26
主要担心ADP前途不明，我还是在用ODBC。不过，ADP有它的不少优点。

我原先在win8.1下adp写了一个很大的内部管理系统，adp+win8.1+sql2012，升级到win10后，可以打开adp但无法运行程序，打开表提示找不到对象

yyb7858

我原先在win8.1下adp写了一个很大的内部管理系统，adp+win8.1+sql2012，升级到win10后，可以打开adp但无法运行程序，打开表提示找不到对象

hwhwenha01

有不有中文版的啊！

李力军2

zhuyiwen 发表于 2011-8-3 21:15
呵呵，我几乎一直在用ADP，我觉得它非常不错。

朱总，您 这么精退ADP，能不能出一本ADP的书啊，我知道很多朋友都想要的！

李力军2

朱总，我想学用ADP多少年了，可一直无从着手，请指点啊！

mclly2000

用服务器去处理数据的确是很爽的事情

weidunw

谢谢分享。顶帖致敬。

李力军2

我一直想用ADP，只可惜还没有实践过

zhuyiwen

其实，使用 ADP 可以更专注 SQL Server 端的开发。我发现 SQL Server 端开发好了，Access 端的开发会变得很简单。
SQL Server 端的开发却是版本超高越好，例如，SQL Server 2005 增加了用 VB.NET、C#书写存储过程、聚合函数(CLR)，SQL Server 2008 增加了在 SQL Server Management Studio 中调试 SQL 语句(函数、存储过程)的功能，简直是爽透了。你甚至可以把所有的业务规则都封装到数据库中，而不是Access的客户端中。