[書(shū)籍-ADP專著]Microsoft Access Projects With Microsoft SQL Server

zhuyiwen

Microsoft Access Projects With Microsoft SQL Server

這本書(shū)專講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中是什么格式了，還會(huì)不會(huì)更新？

zhuyiwen

ADP的格式?jīng)]變，還是沿用2002-2003格式，但是同樣擁有新UI的增強(qiáng)功能，新增的宏的功能以及窗體內(nèi)嵌宏同樣可以應(yīng)用到ADP。

至于前途如何，是MS的事情，無(wú)法判別，至少目前Access整個(gè)都沒(méi)有使用.Net技術(shù)，呵呵。

仁者見(jiàn)仁，智者見(jiàn)智。
如果你的客戶都是使用正版的Office 2010，那就建議你使用2010，否則還是用2007及以前版本比較合適。

tmtony

好書(shū)！，ADP還是有一定的用戶群。

zhuyiwen

tmtony 發(fā)表于 2011-7-31 18:29
好書(shū)！，ADP還是有一定的用戶群。

呵呵，我?guī)缀跻恢痹谟肁DP，我覺(jué)得它非常不錯(cuò)。

tmtony

主要擔(dān)心ADP前途不明，我還是在用ODBC。不過(guò)，ADP有它的不少優(yōu)點(diǎn)。

zhuyiwen

ADP的主要弱點(diǎn)項(xiàng)目只能連接只能是一個(gè)SQLServer數(shù)據(jù)庫(kù)連接，當(dāng)然你的程序可以使用另外的ADO連接來(lái)連接其它數(shù)據(jù)庫(kù)；另一個(gè)弱點(diǎn)是它不能像mdb那樣使用鏈接表和本地表在一起使用數(shù)據(jù)，但你可以使用SQLServer的鏈接數(shù)據(jù)庫(kù)功能，不過(guò)它只在服務(wù)器端；還有一個(gè)弱點(diǎn)就是ADP自始至終都與數(shù)據(jù)庫(kù)連接著，也許它對(duì)于一般應(yīng)用來(lái)說(shuō)，根本就不是弱。

與本地?cái)?shù)據(jù)庫(kù)交換數(shù)據(jù)只能通過(guò)ADO來(lái)實(shí)現(xiàn)。

如果作為一般的小型項(xiàng)目，這些缺點(diǎn)就都不明顯。

zyp

謝謝朱大哥. 英文的看不太懂.
現(xiàn)在做的數(shù)據(jù)庫(kù)大部分都是用ADP的.

fengxueysh

adp的  我在用

sql999

請(qǐng)問(wèn)朱哥，如何用VBA代碼更改宏安全性的級(jí)別設(shè)置(設(shè)置為低)？
我希望是在啟動(dòng)窗體的加載事件中，直接在代碼中將宏安全級(jí)別設(shè)置為低，從而避免彈出宏安全提示。先謝了