Access 2007（Vista）2000或2003应用程序缓慢 [英] 2000 or 2003 app slow in Access 2007 (Vista)
问题描述
大家好，
所以我10天前买了一台新笔记本电脑用Vista测试我的应用程序。 （家庭保险费）
显然Office 2007已预先安装。 （时间有限但完整的测试版本，没有SP1）
所以我借此机会在实际踩踏之前测试Access2007的一些新功能。
First困扰我的当然是''功能区'，但我现在的问题是关于速度。
我在Access 2007中打开了一个Access 2000应用程序。
速度和响应能力都很糟糕！在我看来，趟过泥泞。
打开一张未绑定的表格需要2-3秒......关闭表格也是......
将应用程序转换为Access 2003格式后速度是相同的（坏）
即使转换为Access 2007 accdb ....
In Access 2000或Access 2003应用程序''snappy''。
使用了几个应用程序进行了测试，但我得到了相同的结果。
- 名称自动更正已关闭
--Backend（Acc2000）with subdatasheets< none>
试图安装SP1但是安装简直失败了......
经过检查的参考文献，尝试过反编译，尝试过紧凑，尝试导入干净的数据库等等。
任何想法都是？我必须在这里遗漏一些明显的东西...
Arno R
Hi all,
So I bought a new laptop 10 days ago to test my apps with Vista. (home premium)
Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1)
So I take the opportunity to test some new features of Access2007 before actually ''stepping over''.
First thing that troubles me of course is ''the ribbon'', but my question now is about speed.
I opened one of my Access 2000-apps in Access 2007.
Speed and responsiveness is bad! It appears to me like ''wading through the mud''.
Opening an unbound form takes 2-3 seconds... Closing a form also...
After converting the app to Access 2003 format speed is the same (bad)
Even after converting to Access 2007 accdb ....
In Access 2000 or Access 2003 the app is ''snappy''.
Tested with a couple of more apps, but I am getting the same results.
--Name auto correct is off
--Backend (Acc2000) with subdatasheets <none>
Tried to install SP1 but that install simply failed...
Checked references, tried decompile, tried compact, tried import in clean db and such.
Any idea''s ? I must be missing something obvious here...
Arno R
推荐答案
" Arno R" < ar **************** @ planet.nlwrote在
新闻：47 *************** ********@text.nova.planet.nl：
"Arno R" <ar****************@planet.nlwrote in
news:47***********************@text.nova.planet.nl :
大家好，
所以我10天前买了一台新笔记本电脑用Vista测试我的应用程序。 （家庭
premium）显然Office 2007已预先安装。 （时间有限但是完全测试版本没有SP1）所以我借此机会在实际踩踏之前测试一些
的Access2007新功能。第一个
让我烦恼的事情当然是''功能区''，但我现在的问题
是关于速度的。
我在Access 2007中打开了一个Access 2000应用程序。
速度和响应能力都很糟糕！在我看来，就像趟过泥泞。打开一个未绑定的表单需要2-3秒...关闭表单
也...
将应用程序转换为Access 2003格式后，速度是相同的
（差）即使转换为Access 2007 accdb ....
在Access 2000或Access 2003中，该应用程序是''snappy''。
测试了几个应用程序，但我得到了相同的结果。
- 名称自动更正关闭
--Backend（Acc2000）with subdatasheets< none>
试图安装SP1，但安装失败...
已检查参考，尝试反编译，尝试过紧凑，尝试导入
干净db等等。
任何想法都是？我必须在这里遗漏一些明显的东西...
Arno R
Hi all,
So I bought a new laptop 10 days ago to test my apps with Vista. (home
premium) Apparently Office 2007 is pre-installed. (a time limited but
complete test version, no SP1) So I take the opportunity to test some
new features of Access2007 before actually ''stepping over''. First
thing that troubles me of course is ''the ribbon'', but my question now
is about speed.
I opened one of my Access 2000-apps in Access 2007.
Speed and responsiveness is bad! It appears to me like ''wading through
the mud''. Opening an unbound form takes 2-3 seconds... Closing a form
also...
After converting the app to Access 2003 format speed is the same
(bad) Even after converting to Access 2007 accdb ....
In Access 2000 or Access 2003 the app is ''snappy''.
Tested with a couple of more apps, but I am getting the same results.
--Name auto correct is off
--Backend (Acc2000) with subdatasheets <none>
Tried to install SP1 but that install simply failed...
Checked references, tried decompile, tried compact, tried import in
clean db and such.
Any idea''s ? I must be missing something obvious here...
Arno R
我在带有Intel的桌面上运行Office 2007 E6750（双）cpu和2演出
ram。这很好，如果没有快速的话也很快。
但是对于其他的，使用单处理器的旧电脑，它已经很慢了，而且我已经卸载了很慢它重新安装了Office 2000,2002
或2003，具体取决于看起来合适的内容（例如，在
赛扬1.7上的Office 2000）。
如果我要广泛使用Office 2007，我会看一个四核处理器和64位操作系统，这样我就可以访问几个演出
的ram 。
但也许我做错了。
-
lyle fairfield
我会出现现在去，
总是白天和黑夜
我听到湖水舔水
低音岸边;
当我站在巷道上时
或在人行道上灰色，
我听到它在深处的核心。
- Yeats
I run Office 2007 on a desktop with an Intel E6750 (dual) cpu and 2 gigs
of ram. It''s fine, fast if not snappy.
But on other, older computers with a single processor it''s been
gruesomely slow and I''ve uninstalled it and reinstalled Office 2000, 2002
or 2003 depending on what seemed suitable (for instance, Office 2000 on a
Celeron 1.7).
If I were going to work with Office 2007 extensively I''d look at a quad
processor, and a 64 bit operating system so I could access several gigs
of ram.
But maybe I''m doing something wrong.
--
lyle fairfield
I will arise and go now,
For always night and day
I hear lake water lapping
With low sounds by the shore;
While I stand on the roadway
Or on the pavements gray,
I hear it in the deep heart''s core.
- Yeats
人们会假设一台全新的机器将是理性的很快，但是你可能会因为双重打击而受到打击！
我刚读了一篇论文，我认为它来自ZDNet，据报道，很多很多新的笔记本电脑都没有足够强大的功能来运行Vista的所有铃声
和口哨声。我已经看过用户的报告，运行各种PC，其中很多都是最先进和强大的，抱怨ACC2007上帝很可怕
运行速度慢-2003应用程序。我还没有看到任何人找到了这个问题的答案。
Allen Browne一直在做很多测试2007年从
之前的版本升级，也许他会徘徊并启发我们！
Linq
-
总是有不止一种方法可以给猫皮肤了！
基于Access 2000/2003的答案/帖子
通过 http://www.accessmonster.com 发布消息
One would assume a brand new machine would be reasonably fast, but it may be
that you''re getting hit with a double whammy!
I just read a paper, I think it was from ZDNet, that reported that many, many
new laptops were simply not powerful enough to run Vista with all its bells
and whistles. And I''ve seen reports from users, running various PCs, many of
them state of the art and powerful, complaining of ACC2007 being god awful
slow in running 2000-2003 apps. What I haven''t seen is anyone who''s found an
answer to the problem!
Allen Browne has been doing a lot of testing with 2007 and upgrading from
previous versions, perhaps he''ll wander by and enlighten us!
Linq
--
There''s ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via http://www.accessmonster.com
每个版本的Access都比同一硬件上的版本慢。
就像玩世不恭的Wirth定律一样：
软件变得比硬件变慢更快。
（来源： http://en.wikipedia.org/wiki/Wirth%27s_law ）
所以，是的，A2007比之前版本慢同样，对于某些操作来说，Vista比WinXP要慢得多（特别是
删除大文件。）并且驱动程序的开发程度要低得多。当Vista
首次发布时，A2007的设计视野非常缓慢，从一个房产到另一个房产的标签延迟差不多1秒钟，我不断
发现自己输入了错误的属性。
nVidia发布了新的驱动程序，这在很大程度上得到了解决。
Office 2007 SP1也解决了一些性能问题。恕我直言，A2007没有
SP1无法使用 - 不是从性能角度来看，而是只是不可靠。
在SP1出现之前，我的所有非平凡应用程序都无法可靠地运行
已经发布了，所以我肯定不会推荐它用于任何超出
体验的目的（这是OP的目标。）有些问题没有在
SP1（例如，将特定的打印机分配给报告），但它现在可以使用（虽然没有比原始版本快得多）。一个主要修复是
使用之前的版本后启动A2007时的延迟（从我的机器上的3.5分钟到25分钟到18秒）。
那里在Vista下运行Access（任何版本）的其他问题，比如
RunAsAdministrator，避免使用虚拟文件夹，避免离线
文件夹，以及密集查询的性能不佳： br /> http://allenbrowne.com/VistaCPULoad.html
OP在笔记本电脑上运行。正如Linq Adams所说，许多笔记本电脑都有限制咕噜声，内存更加有限，以及图形处理能力差（盗取更多的系统内存）。
建议：
1.关闭Aero。如果
笔记本电脑响应更快，你可以没有漂亮的半透明窗户。
2.删除免费计算机上安装的软件。
特别是，Norton和其他人的安全措施意味着文件
正在被慢速旋转的笔记本驱动器中的泥浆拖走。
3.如果您的RAM少于2MB，请考虑添加更多内容。
如果您不能这样做，请减少一次打开的程序数。
您可能已经阅读过Tony对Access性能的建议：
http://www.granite.ab.ca/access/performancefaq.htm
-
Allen Browne - 微软MVP。西澳大利亚珀斯
访问用户提示 - http：// allenbrowne .com / tips.html
回复群组，而不是mvps dot org的allenbrowne。
" Linq Adams via AccessMonster.com" ; < u28780 @ uwewrote in message
news：7e7844d18df8a @ uwe ...
Each version of Access is slower than the one before on the same hardware.
Like the cynical Wirth''s law:
Software gets slower faster than hardware gets faster.
(Source: http://en.wikipedia.org/wiki/Wirth%27s_law )
So, yes, A2007 is slower than previous versions.
Similarly, Vista is much slower that WinXP for some operations (particularly
deleting large files.) And the drivers are much less developed. When Vista
was first released, A2007 was so slow in design view, that there was almost
1 second delay in tabbing from one property to the next, and I constantly
found myself typing into the wrong property. This was largely solved when
nVidia released new drivers.
Office 2007 SP1 also addressed some performance issues. IMHO, A2007 without
SP1 is unusable - not from a performance perspective, but just unreliable.
None of my non-trivial apps would work reliably for all cases until SP1 was
released, so I would certainly not recommend it for any purpose beyond
experiementation (which was the OP''s goal.) Some issues were not solved in
SP1 (e.g. assigning a specific printer to a report), but it''s now quite
usable (though not hugely faster than the original release.) A major fix was
the delay when starting A2007 after using a previous version (down from 3.5
minutes to 18 seconds on my machine.)
There are other issues running Access (any version) under Vista, like
RunAsAdministrator, avoiding the virutalized folders, avoiding off-line
folders, and poor performance of intensive queries:
http://allenbrowne.com/VistaCPULoad.html
The OP was running on a laptop. As Linq Adams says, many laptops have
limited grunt, even more limited RAM, and poor graphics processing (stealing
even more system RAM.)
Suggestions:
1. Turn Aero off. You can live without the pretty translucent windows if the
laptop is more responsive.
2. Remove the "free" software that came installed on your computer.
Particuarly, the security stuff from Norton and others mean that the files
are being dragged through mud off your slow-spinning notebook drive.
3. If you have less than 2MB of RAM, consider adding more.
If you cannot do that, reduce the number of programs open at once.
You have probably already read Tony''s suggestions for Access performance:
http://www.granite.ab.ca/access/performancefaq.htm
--
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.
"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:7e7844d18df8a@uwe...
人们会认为一台全新的机器会相当快，但它可能会因为双重打击而被b
$ b！
我刚看了一篇论文，我认为这是来自ZDNet，据报道，许多，
很多
新款笔记本电脑根本没有足够强大的功能来运行Vista所有的
铃声
和口哨声。我已经看过用户的报告，运行各种PC，很多
他们是最先进和强大的，他们抱怨ACC2007上帝很可怕
运行2000-2003应用程序的速度很慢。我没有看到的是有人找到了这个问题的b $ b $
回答问题！
Allen Browne 2007年已经进行了大量的测试并从之前的版本升级了
，也许他会徘徊并启发我们！
Linq
One would assume a brand new machine would be reasonably fast, but it may
be
that you''re getting hit with a double whammy!
I just read a paper, I think it was from ZDNet, that reported that many,
many
new laptops were simply not powerful enough to run Vista with all its
bells
and whistles. And I''ve seen reports from users, running various PCs, many
of
them state of the art and powerful, complaining of ACC2007 being god awful
slow in running 2000-2003 apps. What I haven''t seen is anyone who''s found
an
answer to the problem!
Allen Browne has been doing a lot of testing with 2007 and upgrading from
previous versions, perhaps he''ll wander by and enlighten us!
Linq
这篇关于Access 2007（Vista）2000或2003应用程序缓慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
