Access 数据项目 (ADP) - Access 2007 还是 2003？
我的任务是使用 Access 编写 ADP 应用程序。后端数据将存储在SQL Server中。我们可以使用 SQL Server 2000、2005 和 2008。要求规定必须使用 Access，但我可以选择使用 Access 2003 或 Access 2007。我的第一个想法是推动 Access 2007，因为它更新，我们可以使用 SQL Server 2005 或也许 2008，但是，在搜索时Access 2007 和 ADP 的网络 我发现很多人发帖说速度非常慢，并且他们在使用 ADP 运行 Access 2007 时遇到了很多问题。
如果您可以选择在 Access 数据库项目中使用 Access 2003 或 Access 2007，您会选择哪一个？为什么？谢谢。
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.
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
就我个人而言，我觉得 Office 2007 还不错，但 Access 2007 UI 确实让我感到沮丧！对象文本搜索功能很有用，但我怀念能够看到完整的对象列表和说明。
至于数据方面，如果您有自由选择，我会使用 MDB 文件并使用 ODBC 链接表链接到 SQLServer，而不是使用 ADP。显然，ADP 已被弃用，因为它们效率较低。请参阅评论 这里。这是摘录：
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.
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: