关于Access 2007的意见 [英] Opinion on Access 2007
问题描述
如果您正在寻找有关Access 2007中有用的信息，那么有一篇新的
文章：
http://allenbrowne.com/Access2007.html
涵盖什么是好的（有用的功能），什么是混合（好的和坏的），什么是'b $ b消失了（功能被删除），什么是固定的（旧问题解决了），什么是破碎的
（新错误），配置，兼容性，你应该购买和链接。
这是意见，所以你可能不同意，但希望它''一个内容丰富的
摘要。
-
Allen Browne - 微软MVP。西澳大利亚珀斯
访问用户提示 - http：// allenbrowne .com / tips.html
回复群组，而不是mvps dot org的allenbrowne。
据我所知，ADP尚未从Access 2007中删除;然而，它似乎已经完全搞砸了速度。 。
我已经使用Beta版完成了所有测试，我必须重复它们
与RTM一起确定;但是，我在
新闻组中读到的一些消息也有同样的结论。例如：
http://groups.google.ca/group/micros...5419790b476f53
（我之前测试的简短故事）使用测试版：当在具有256Megs分配内存的
虚拟机中运行时，我不得不终止整个
作业以重新获得对PC的控制并在运行时分配了512兆，
这是一个缓慢的爬行。在SQL-Server上的分析显示原因是
关于对象属性的大量查询
SQL-Server以及每次移动鼠标时重复这些查询
从一个字段到另一个字段，甚至在一个字段内的256 Megs
已分配内存。在相同的
VM中运行MDB文件时完全没问题。）
所以y你应该将ADP功能从什么消失的部分移动到
完全拧紧的部分。
-
Sylvain Lafontaine，ing。
MVP - Technologies Virtual-PC
电子邮件：sylvain aei ca（填空，请不要发送垃圾邮件）
Allen Browne < Al ********* @ SeeSig.invalidwrote in message
news：45 ********************* ** @ per-qv1-newsreader-01.iinet.net.au ...
如果您正在寻找有关Access 2007中有用的内容的意见，有一篇
新文章：
http ：//allenbrowne.com/Access2007.html
涵盖什么是好的（有用的功能），什么是混合（好的和坏的），什么' 's
消失了（功能已删除），修复了什么（旧问题解决了），破坏了什么
（新错误），配置，兼容性，应该你买，和链接。
这是意见，所以你可能不同意，但希望它是一个内容丰富的
摘要。
-
Allen Browne - 微软MVP。西澳大利亚珀斯
访问用户提示 - http：// allenbrowne .com / tips.html
回复群组，而不是mvps dot org的allenbrowne。
Sylvain Lafontaine（填空，请不要发送垃圾邮件）写道：
据我所知，ADP尚未从Access 2007中删除;然而，它似乎已经完全搞砸了速度。 。
如果你想在装载东西时吃早餐，那就没那么糟了。
< blockquote>" Allen Browne" < Al ********* @ SeeSig.invalidwrote in
news：45 ********************** *@per-qv1-newsreader-01.iinet.net.au:
如果您正在寻找有关Access 2007中有用的信息，那么
有一篇新文章：
http：// allenbrowne.com/Access2007.html
涵盖什么是好的（有用的功能），什么是混合的（好的和坏的），
什么已经消失（功能已删除），修复了什么（旧问题解决了），
破坏了什么（新的错误），配置，兼容性，你是否应该/>
购买和链接。
这是意见，所以你可能不同意，但希望它是一个
信息摘要。
伟大的文章，艾伦 - 我非常感谢你付出的工作
准备它。
Coures，我有疑问！ :)
1.富文本：是HTML *好* HTML，还是通常无用的，可怕的MS
的东西，有复杂和特殊的CSS？ HTML是否可控？
2.次要拼写提示：在嵌入式宏项目下，您的意思是
弃用而不是贬值。相同的大
"兼容性"最后一节。
3.删除的功能部分：我仍然反对人们对待这个问题的方式。安全和复制以及ADP已经从Access中删除了*没有*
- 它们刚刚从新的
数据库格式中省略。除非你是白痴，否则你不会自动开始使用新的数据库格式，对吗？你的意思是
从新的数据库格式中删除。
4.继续＃3：关于复制，说使用
附加表，连接到具有复制的数据库因为在以前版本的Access中使用复制应该是
的方式，因为只有表格应该是
被复制。我认为这对所有这三个问题都有误导性
没有明确说明如果你使用MDB / ADB格式，你继续
具有以前的所有功能Access的版本（它只是
DAP已经被删除，不能在A2K7中创建，
如果我理解正确的话，
）。
5.自动填充：这是一个A2K及更高版本的功能，因此不适用于以前所有版本的
（大量开发人员仍在使用
很多A97的工作，我几乎不记得自动填充功能，
因为我在A2K的表格视图中没有做太多数据编辑而且
稍后）。
6.进口：是否使Excel更好用？也就是说，您现在可以比以前更好地控制数据类型，而不是使用
来确保电子表格格式正确之前
导入？
7.兼容性问题：转换后的MDB中是否存在问题以及新ACCDB中的
？
8.我应该购买部分：我认为新用户不应该购买
，除非他们没有外部依赖。也就是说，他们不会与其他用户共享数据，而且没有任何现有的应用程序与开发人员一起工作。我只是认为
不合格是过于乐观了。当然，我想我是b / b
在第二类方面的思考更多。我仍然认为
第一类不是一个不合格的肯定，而是一个可能。我也不会相信为未来学习。建议，
这是每个人在ADO中引入的建议。
Access。我没有学到它，而且，我对此并不后悔，
，因为微软已经上映，现在它已经在Access中被弃用了。
总的来说，根据你所写的内容，在我看来A2K7是类似于A95的
灾难 - 比A2K更糟糕。
但是，再次，非常感谢 - 我将使用你的文章试图
引导我的任何客户远离购买A2K7。
-
David W. Fenton http：//www.dfenton .com /
usenet at dfenton dot com http ：//www.dfenton.com/DFA/
If you are looking for opinon on what''s useful in Access 2007, there''s a new
article at:
http://allenbrowne.com/Access2007.html
Covers what''s good (useful features), what''s mixed (good and bad), what''s
gone (features removed), what''s fixed (old issues solved), what''s broken
(new bugs), configuration, compatibility, should you buy, and links.
It is opinion, so you may disagree, but hopefully it''s an informative
summary.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
To my knowledge, ADP have not been removed from Access 2007; however, it''s
appears that they are now totally screwed in term of speed. .
I have done all of my tests with the Beta version and I must repeat them
with the RTM to be sure; however, some messages that I''ve read in the
newsgroups share the same conclusion. See for example:
http://groups.google.ca/group/micros...5419790b476f53
(Short story on my previous tests with the beta version: when running in a
virtual machine with 256Megs of allocated memory, I had to kill the whole
job to regain control of my PC and while running it with 512 Megs allocated,
it was a slow crawl. Profiling on the SQL-Server showed that the cause was
an incredible amount of queries made about the properties of objects on the
SQL-Server and that these queries was repeated each time the mouse was moved
from field to field and even inside a field in the case with 256 Megs of
memory allocated. No problem at all when running a MDB file in the same
VM.)
So you should move the ADP feature from the What''s gone section to the
Totally Screwed section.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Allen Browne" <Al*********@SeeSig.invalidwrote in message
news:45***********************@per-qv1-newsreader-01.iinet.net.au...If you are looking for opinon on what''s useful in Access 2007, there''s a
new article at:
http://allenbrowne.com/Access2007.html
Covers what''s good (useful features), what''s mixed (good and bad), what''s
gone (features removed), what''s fixed (old issues solved), what''s broken
(new bugs), configuration, compatibility, should you buy, and links.
It is opinion, so you may disagree, but hopefully it''s an informative
summary.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
Sylvain Lafontaine (fill the blanks, no spam please) wrote:
To my knowledge, ADP have not been removed from Access 2007; however, it''s
appears that they are now totally screwed in term of speed. .It''s not so bad if you want to have breakfast while things load.
"Allen Browne" <Al*********@SeeSig.invalidwrote in
news:45***********************@per-qv1-newsreader-01.iinet.net.au:
If you are looking for opinon on what''s useful in Access 2007,
there''s a new article at:
http://allenbrowne.com/Access2007.html
Covers what''s good (useful features), what''s mixed (good and bad),
what''s gone (features removed), what''s fixed (old issues solved),
what''s broken (new bugs), configuration, compatibility, should you
buy, and links.
It is opinion, so you may disagree, but hopefully it''s an
informative summary.Great article, Allen -- I really appreciate the work you''ve put into
preparing it.
Of coures, I have questions! :)
1. rich text: is the HTML *good* HTML, or the usual trashy, awful MS
stuff, with complex and idiosyncratic CSS? Is the HTML controllable?
2. minor spelling hint: under the embedded macros item, you mean
"deprecate" instead of "depreciate". Same for the big
"compatibility" section at the end.
3. the "features removed" section: I still object to the way people
are treating this. Security and Replication and ADPs have *not*
been removed from Access -- they were just omitted from the new
database format. Unless you''re a moron, you won''t just automatically
start using the new database format, right? What you mean is
"removed from new database format".
4. continuing from #3: In regard to replication, saying "Use
attached tables, connected to a database that has replication" is
rather misleading, as that''s the way replication should have been
used in previous versions of Access, too, since only tables should
be replicated. I think it''s misleading on all three of these issues
to not explicitly say that if you use MDB/ADB format you continue to
have all the functionality of previous versions of Access (it''s only
DAPs that have actually been removed and can''t be created in A2K7,
if I understand correctly).
5. Autofill: that was an A2K and later feature, so doesn''t apply to
all previous versions (significant numbers of developers still do
lots of work in A97, and I barely remember the Autofill feature,
since I don''t do too much data editing in table view in A2K and
later).
6. Imports: have that made it work better for Excel? That is, can
you now control the data types better than before, instead of having
to make sure the spreadsheet is absolutely properly formatted before
the import?
7. Compatibility Issues: is that an issue in converted MDBs as well
as in new ACCDBs?
8. Should I Buy section: I think that new users ought not buy it
unless they have no outside dependencies. That is, they aren''t going
to share data with other users and don''t have any existing
applications with a developer working on them. I just think an
unqualified "YES" is way too optimistic. Of course, I guess I''m
thinking more in terms of your second category. I still think the
first category oughn''t be an unqualified affirmative, but a MAYBE. I
also just don''t believe in the "learn it for the future" advice, as
that was the advice everyone gave for ADO when it was introduced in
Access. I didn''t learn it, and, well, I have no regrets on that,
since Microsoft wised up and it''s now deprecated in Access.
Overall, from what you''ve written, it seems to me that A2K7 is a
disaster similar to A95 -- much worse than A2K.
But, again, thanks very much -- I''ll be using your article to try to
steer any of my clients away from buying A2K7.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
这篇关于关于Access 2007的意见的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
