[书籍-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.

ui

谢谢分享，朱总，ADP前途如何
在2010中是什么格式了，还会不会更新？

zhuyiwen

ADP的格式没变，还是沿用2002-2003格式，但是同样拥有新UI的增强功能，新增的宏的功能以及窗体内嵌宏同样可以应用到ADP。

至于前途如何，是MS的事情，无法判别，至少目前Access整个都没有使用.Net技术，呵呵。

仁者见仁，智者见智。
如果你的客户都是使用正版的Office 2010，那就建议你使用2010，否则还是用2007及以前版本比较合适。

tmtony

好书！，ADP还是有一定的用户群。

zhuyiwen

tmtony 发表于 2011-7-31 18:29
好书！，ADP还是有一定的用户群。

呵呵，我几乎一直在用ADP，我觉得它非常不错。

tmtony

主要担心ADP前途不明，我还是在用ODBC。不过，ADP有它的不少优点。

zhuyiwen

ADP的主要弱点项目只能连接只能是一个SQLServer数据库连接，当然你的程序可以使用另外的ADO连接来连接其它数据库；另一个弱点是它不能像mdb那样使用链接表和本地表在一起使用数据，但你可以使用SQLServer的链接数据库功能，不过它只在服务器端；还有一个弱点就是ADP自始至终都与数据库连接着，也许它对于一般应用来说，根本就不是弱。

与本地数据库交换数据只能通过ADO来实现。

如果作为一般的小型项目，这些缺点就都不明显。

zyp

谢谢朱大哥. 英文的看不太懂.
现在做的数据库大部分都是用ADP的.

fengxueysh

adp的  我在用

sql999

请问朱哥，如何用VBA代码更改宏安全性的级别设置(设置为低)？
我希望是在启动窗体的加载事件中，直接在代码中将宏安全级别设置为低，从而避免弹出宏安全提示。先谢了