访问2003年至2010年的绩效问题 [英] Access 2003 to 2010 Performance Issue

问题描述

我在Xp机器上有一个Access 2003数据库。表是ODBC链接到SQl Server 2005数据库。应用程序中有一个表单需要6秒才能加载。该表单包含一个带有30个选项卡的选项卡式控件，每个选项卡包含一个子表单。 open事件确定
哪个 标签显示和隐藏。

I have an Access 2003 database on Xp machine. Tables are ODBC linked to SQl Server 2005 database. There is a form in the application that takes 6 secs to load. The form contains a tabbed control with 30 tabs, each tab contains a subform. The open event determines which tabs to display and hide.

当它在Access 2007中转换为accdb格式时，相同的表单需要14秒才能加载。在应用office sp2后，打开表单的速度再次大约为6秒。

When it was converted to accdb format in Access 2007 the same form took 14 secs to load. Upon applying office sp2 the speed of opening the form was again about 6 seconds.

然后在Windows 7测试计算机上的Access 2010中打开2007数据库。有问题的表格现在大约需要15秒才能加载。我尝试过反编译，重新编译和压缩，但无济于事。我尝试了通常的Windows 7网络速度问题
修复但无济于事。

The 2007 database was then opened in access 2010 on a windows 7 test machine. The form in question now takes about 15 seconds to load. I have tried decompiling , recompiling and compacting but to no avail. I have tried the usual Windows 7 network speed issues fix but to no avail.

任何建议都将不胜感激。

Any suggestions would be appreciated.

推荐答案

dkearns写道：

dkearns wrote:

我在Xp机器上有一个Access 2003数据库。表是ODBC链接到SQl Server 2005数据库。应用程序中有一个表单需要6秒才能加载。该表单包含一个带有30个选项卡的选项卡式控件，每个选项卡包含一个子表单。 open事件确定
哪些选项卡显示和隐藏。



当它在Access 2007中转换为accdb格式时，相同的表格需要14秒才能加载。在申请办公室sp2后，打开表格的速度再次约为6秒。

I have an Access 2003 database on Xp machine. Tables are ODBC linked to SQl Server 2005 database. There is a form in the application that takes 6 secs to load. The form contains a tabbed control with 30 tabs, each tab contains a subform. The open event determines which tabs to display and hide.

When it was converted to accdb format in Access 2007 the same form took 14 secs to load. Upon applying office sp2 the speed of opening the form was again about 6 seconds.

有趣的是。

然后在Windows 7测试计算机上的Access 2010中打开2007数据库。有问题的表格现在大约需要15秒才能加载。我尝试过反编译，重新编译和压缩，但无济于事。我已经尝试了通常的Windows 7网络速度问题
修复但无济于事。

The 2007 database was then opened in access 2010 on a windows 7 test machine. The form in question now takes about 15 seconds to load. I have tried decompiling , recompiling and compacting but to no avail. I have tried the usual Windows 7 network speed issues fix but to no avail.

两种不同的方法来解决这个问题。 传统的方法是在单击选项卡时只填充子表单记录源。

Two different ways of approaching this.  The traditional way is to only
fill the sub forms recordsource when the tab is clicked.

另一种方法填充传递参数的子表单记录集。   我认为，a
客户端使用ADO调用存储过程，通过

参数返回记录集。  但是我对这里的细节很模糊了。
这里。

The other way fill the subforms recordset passing in the parameters.   A
client is, I think, using ADO to call a stored procedure passing
parameters which returns a recordset.   However I'm fuzzy on the details
here.

Tony

这篇关于访问2003年至2010年的绩效问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！