优化表格？ [英] OPTIMIZING A FORM?

问题描述

我有一个非常繁忙的输入表单，有大约6个图形按钮和6个

嵌入式子表单。


数据库后端位于本地网络上;前端

将出现在每个用户的C：\驱动器上。


这需要很长时间才能加载：我确实进去了。

重新索引表格，这极大地加快了速度。


我还能做些什么来优化性能？截至目前，

在测试中，当2个用户同时尝试点击输入表格时，

访问为其中一个访问死亡。


谢谢！


amy

===

I have a very busy input form that has about 6 graphical buttons and 6
embedded subforms.

The database backend is located on a local network; the front ends
will be on each user''s C:\ drive.

It is taking a long, long time for this to load: I did go in and
reindex the tables, which speeded things up tremendously.

Is there anything else I can do to optimize performance? As of now,
in testing, when 2 users try to hit the input form at the same time,
Access dies for one of them.

Thanks!

amy
===

推荐答案

在线评论...


2004年7月16日13:56:14 -0700， am ******* @ verizon.net （amywolfie）

写道：

Comments in-line...

On 16 Jul 2004 13:56:14 -0700, am*******@verizon.net (amywolfie)
wrote:

我有一个非常繁忙的输入表单，有大约6个图形按钮和6个嵌入的子表单。
什么样的图形？某些类型加载速度比其他类型快（我有
发现BMP加载速度最快。


如果你可以根据需要加载（设置）子表单RecordSource。

打开表单时将它们清空。

数据库后端位于本地网络上;前端
将位于每个用户的C：\上驱动。
你的意思是*将*在当地的驱动器上。他们现在共享一个

E吗？

这需要很长很长的时间加载的时间：我确实进入并重新索引表格，这极大地加速了表格。

我还能做些什么来优化性能？截至目前，访问其中一个表格。

谢谢！

amy
===

I have a very busy input form that has about 6 graphical buttons and 6
embedded subforms. What kind of graphics? Some types load faster than others. (I have
found that BMPs load the fastest.

If you can load (set) the subforms RecordSource just as you need them.
Have them empty when the form is opened.

The database backend is located on a local network; the front ends
will be on each user''s C:\ drive. What do you mean by *will* be on the local drive. Are they sharing an
E now?

It is taking a long, long time for this to load: I did go in and
reindex the tables, which speeded things up tremendously.

Is there anything else I can do to optimize performance? As of now,
in testing, when 2 users try to hit the input form at the same time,
Access dies for one of them.

Thanks!

amy
===

除了Jim的评论，你会发现很多优化信息
这个链接是
。

http://www.granite.ab.ca/access/performancefaq.htm


-

Wayne Morgan

MS Access MVP

" Jim Allensworth" <ジ**** @ datacentricsolutions.com>在留言中写道

news：40 **************** @ news.west.earthlink.net ...

In addition to Jim''s comments, you will find a lot of optimizing information
at this link.

http://www.granite.ab.ca/access/performancefaq.htm

--
Wayne Morgan
MS Access MVP
"Jim Allensworth" <ji****@datacentricsolutions.com> wrote in message
news:40****************@news.west.earthlink.net...

评论在线...

2004年7月16日13:56:14 -0700，上午** *****@verizon.net （amywolfie）
写道：

Comments in-line...

On 16 Jul 2004 13:56:14 -0700, am*******@verizon.net (amywolfie)
wrote:

我有一个非常繁忙的输入表单，有大约6个图形按钮和6 <嵌入式子窗体。

I have a very busy input form that has about 6 graphical buttons and 6
embedded subforms.

什么样的图形？某些类型加载速度比其他类型快（我已经发现BMP加载速度最快。

如果您可以根据需要加载（设置）子表单RecordSource。
打开表单时将它们清空。

What kind of graphics? Some types load faster than others. (I have
found that BMPs load the fastest.

If you can load (set) the subforms RecordSource just as you need them.
Have them empty when the form is opened.

数据库后端位于本地网络上;前端
将位于每个用户的C：\驱动器上。

The database backend is located on a local network; the front ends
will be on each user''s C:\ drive.

你是什么意思*将*在本地驱动器上。他们现在共享一个
E吗？

What do you mean by *will* be on the local drive. Are they sharing an
E now?

它正在服用很长很长一段时间才能加载：我确实进入并重新索引表格，这极大地加速了表格。

我还能做些什么来优化性能？现在，
在测试中，当2个用户同时尝试点击输入表格时，
访问其中一个表格。

谢谢！

amy
===

It is taking a long, long time for this to load: I did go in and
reindex the tables, which speeded things up tremendously.

Is there anything else I can do to optimize performance? As of now,
in testing, when 2 users try to hit the input form at the same time,
Access dies for one of them.

Thanks!

amy
===

啊，是Tony的常见问题解答。


我去过那里已经有一段时间了 - 很多新的东西。


优秀的资源。


- Jim


2004年7月16日星期五22:18:35 GMT，Wayne Morgan

< co *************************** @ hotmail.com>写道：

Ah, yes Tony''s FAQ.

It has been a while since I have been there - a lot of new stuff.

Excellent resource.

- Jim

On Fri, 16 Jul 2004 22:18:35 GMT, "Wayne Morgan"
<co***************************@hotmail.com> wrote:

除了Jim的评论，你会在这个链接上找到很多优化信息。

http://www.granite.ab.ca/access/performancefaq.htm

- 韦恩摩根
MS Access MVP

In addition to Jim''s comments, you will find a lot of optimizing information
at this link.

http://www.granite.ab.ca/access/performancefaq.htm

--
Wayne Morgan
MS Access MVP

这篇关于优化表格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！