作为SQL Server的前端访问-ADO与DAO? [英] Access as a front-end to SQL Server - ADO vs DAO?

问题描述

我有一个项目，它将使用Access 2003作为前端，并且数据将存储在SQL Server中. Access将通过链接表与SQL Server中的所有数据库逻辑(存储过程，视图)连接到SQL Server.

I have a project that will be using Access 2003 as the front-end and the data will be stored in SQL Server. Access will connect to SQL Server via linked tables with all the database logic (stored procedures, views) within SQL Server.

鉴于此设置，在Access中使用ADO或DAO会更好吗?它只是一个偏好问题，还是更适合作为前端访问和将SQL Server作为数据存储使用?特别是在使用链接表时.谢谢.

Given this setup, would it be better to use ADO or DAO within Access? Is it just a matter of preference or is one more suited to Access as a front-end and SQL Server as the data store? Especially when using linked tables. Thanks.

推荐答案

编写直通查询，而不是链接表方法.性能将大大提高.编写Access应用程序?

Write pass-thru queries as opposed to the linked table approach. Performance will be greatly improved. Writing an Access app?

创建一些本地表来存储一些查询结果.您可以根据需要动态更改直通查询以及用于连接到多个数据库的连接信息.

Create some local tables to store some query results. You can dynamically change the pass-thru queries as needed as well as connection info for connecting to multiple databases.

普遍共识是ADO用于连接到sql服务器/其他源，而DAO仅用于mdb.

General consensus is ADO for connecting to sql server/other sources and DAO for mdb only sources.

这篇关于作为SQL Server的前端访问-ADO与DAO?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！