如何优化Access数据库

来源： 作者： 出处：巧巧读书 2006-11-07 进入讨论组

• 关 键 词：
• access数据库
• combo

　　How to speed up database access

Here is a trick to loop through a recordset faster. Often when looping through a recordset people will use the following code:

Do While Not Records.EOF
  Combo1.AddItem Records![Full Name]
  Eecords.Movenext
LoopThe problem is that everytime the database moves to the next record it must make a check to see if it has reached the end of the file. This slows the looping down a great deal. When moving or searching throuch a large record set this can make a major difference. Here is a better way to do it.

Records.MoveLast
intRecCount=Records.RecordCount
Records.MoveFirst

For intCounter=1 To intRecCount
  Combo1.AddItem Records![Full Name]
  Records.MoveNext
Next intCounterYou should see about a 33% speed increase.本U R L:http://www.qqread.com/access/s275752.html 更多内容请看系统优化大全、Access、数据库专栏专题，或进入讨论组讨论。

【收藏此文】【大 中 小】【打印】【关闭】

较早的文章：改变ACCESS数据库的密码

较新的文章：删除Access数据库中的所有数据