访问数据项目(ADP)-Access 2007或2003? [英] Access Data Project (ADP) - Access 2007 or 2003?

问题描述

我的任务是使用Access编写ADP应用程序.后端数据将存储在SQL Server中.我们提供了SQL Server 2000、2005和2008.要求表明必须使用Access，但是我可以选择使用Access 2003或Access2007.我的第一个想法是推动Access 2007，因为它较新，我们可以在搜索时使用SQL Server 2005或2008.在Access 2007和ADP的Web上，我发现有很多人说速度非常慢，并且使Access 2007与ADP一起运行时他们遇到了很多问题.

I have been tasked with writing an ADP application using Access. The back-end data will be stored in SQL Server. We have SQL Server 2000, 2005, and 2008 available to us. Requirements dictate that Access must be used but I may have a choice of using Access 2003 or Access 2007. My first thought was to push for Access 2007, because it was newer and we could use SQL Server 2005 or perhaps 2008, however, when searching the web for Access 2007 and ADP I find a lot of posts from people saying the speed is very slow and they are running into lots of problems getting Access 2007 running with ADP.

如果您选择对Access数据库项目使用Access 2003或Access 2007，将选择哪一个?为什么?谢谢.

If you had the choice of using Access 2003 or Access 2007 for an Access Database Project which one would you go with and why? Thanks.

推荐答案

我个人认为Office 2007可以，但是Access 2007 UI确实让我感到沮丧！对象文本搜索功能很有用，但是我想念一下却无法看到对象的完整列表.

Personally, I find Office 2007 to be ok, but the Access 2007 UI really gets me frustrated! The object text search feature is useful, but I miss being able to see a full list of objects, with descirption.

关于数据方面，如果您有选择的余地，我将使用MDB文件并使用ODBC链接表链接到SQLServer，而不是使用ADP.显然，不推荐使用ADP，因为它们的效率较低.请参阅评论

As to the data side of things, if you have a free choice, I'd use a MDB file and link to SQLServer using ODBC linked tables, rather than use a ADP. Apparently, ADPs are deprecated as they are less efficient. See the comments here. Here's an excerpt:

但不通过Jet是 缺点，因为Jet非常聪明 高效的. ADO存在严重问题 (例如绕过视图并直接进入 到基础表，否则 不可更新的DML命令)和ADP 原来之间有更多的层次 它们和数据比带有ODBC的MDB还要多. 这就是MS一直不赞成的原因 支持MDB/ODBC的ADP大约有5个 几年了.

But not going through Jet is a drawback, because Jet is so smart and efficient. ADO has terrible problems (like bypassing views and going direct to the underlying tables for otherwise unupdatable DML commands) and ADPs turn out to have more layers between them and the data than MDBs with ODBC. This is why MS has been deprecating ADPs in favor of MDB/ODBC for about 5 years now.

这篇关于访问数据项目(ADP)-Access 2007或2003?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！