Access 2002性能问题 [英] Access 2002 Performance Issues
问题描述
我最近从Access 97升级到Access 2002&性能
基本上很臭。我已经尝试了下面列出的下列项目，但是
只产生了轻微的影响：
1）将Jet 4升级到Service Pack 7
2）从[自动]将子数据表名称设置为[无]
3）缩短.MDB文件的文件名
4）确保跟踪名称自动更正信息已关闭
除此之外我将在SQL中运行索引调整向导，以查看
（如果有任何影响）。 br />
非常感谢任何其他建议。
谢谢
John
Hi,
I''ve recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet 4 to Service Pack 7
2) Set Subdatasheet Name to [None] from [Auto]
3) Shortened the file name of the .MDB file
4) Made sure the Track name AutoCorrect info is off
Other than that I''m going to run the Index Tuning Wizard in SQL to see
if that has any impact.
Any other suggestions would be greatly appreciated.
Thanks
John
推荐答案
没有关于环境的一些信息......你拥有什么以及你用b $ b b b做什么......很可能无法帮助。而且，
表现基本上很臭并没有真正让我们继续下去。澄清
有关这些问题的一些细节，也许有人可以提供帮助。
同时，特别是如果它是一个拆分数据库，多用户，
网络中不同机器上的数据，访问MVP Tony Toews的网站，
http://www.granite.ab.ca/accsmstr.htm 。他拥有最好的
信息和多用户Access-Jet性能链接，并且避免了我所知道的
腐败。
Larry Linson
Microsoft Access MVP
" John" < JF ******* @ focusintegrated.com>在消息中写道
news：71 ************************** @ posting.google.c om ...
Without some information on the environment... what you have and what you
are doing with it... it is likely to be impossible to help. And,
"performance basically stinks" doesn''t really give us much to go on. Clarify
with some detail on these issues and perhaps someone can help.
In the meanwhile, particularly if it is a split database, multiuser, with
the data on a different machine in the network, visit MVP Tony Toews'' site,
http://www.granite.ab.ca/accsmstr.htm. He has the best collection of
information and links on multiuser Access-Jet performance and avoiding
corruption that I know of.
Larry Linson
Microsoft Access MVP
"John" <jf*******@focusintegrated.com> wrote in message
news:71**************************@posting.google.c om...
我最近从Access 97升级到Access 2002&性能基本上很臭。我尝试了下面列出的以下项目，但它只产生了轻微的影响：
1）将Jet 4升级到Service Pack 7
2）将子数据表名称设置为[无]来自[Auto]
3）缩短.MDB文件的文件名
4）确保曲目名称自动更正信息已关闭
除此之外我是将在SQL中运行Index Tuning Wizard以查看
是否有任何影响。
任何其他建议将不胜感激。
谢谢
John
Hi,
I''ve recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet 4 to Service Pack 7
2) Set Subdatasheet Name to [None] from [Auto]
3) Shortened the file name of the .MDB file
4) Made sure the Track name AutoCorrect info is off
Other than that I''m going to run the Index Tuning Wizard in SQL to see
if that has any impact.
Any other suggestions would be greatly appreciated.
Thanks
John
jf **** ***@focusintegrated.com （John）写道：
jf*******@focusintegrated.com (John) wrote:
我最近从Access 97升级到Access 2002&性能基本上很臭。我尝试了下面列出的以下项目，但它只产生了轻微的影响：
1）将Jet 4升级到Service Pack 7
2）将子数据表名称设置为[无]来自[Auto]
3）缩短.MDB文件的文件名
4）确保曲目名称自动更正信息已关闭
I''ve recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet 4 to Service Pack 7
2) Set Subdatasheet Name to [None] from [Auto]
3) Shortened the file name of the .MDB file
4) Made sure the Track name AutoCorrect info is off
LDB锁定持久记录集连接或始终打开绑定表单
更正（多个用户）
有关这些的更多信息，不太可能的原因，其他MS KB的提示和链接
文章访问我的访问性能常见问题页面
http://www.granite.ab.ca/access/performancefaq.htm
Tony
-
Tony Toews，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以
阅读整个消息主题。
Microsoft Access Links，Hints，Tips& ;会计系统
http://www.granite.ab.ca /accsmstr.htm
>任何其他建议将不胜感激。
可能是你不喜欢的;回到Access 97.我做了。
我希望它能在未来的操作系统上运行数十年。
> Any other suggestions would be greatly appreciated.
Probably one that you won''t like; go back to Access 97. I did.
I just hope that it will work for decades on upcoming OS.
这篇关于Access 2002性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
