• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

Help with DBengine.idle

I have an Access 2003 database that runs over a rather slow network.  I use the DBEngine.idle function before a refresh and other processes.  But, I would like to know if it actually makes a difference to reliability / performance.

I could just do with a bit of feed back on this one.

Andy Brown
Andy Brown
  • 2
1 Solution
Hi Andrew, is this a multi user environment? If not then it will not really make much difference.

If multiuser then there is a chance of performance improvement due to memory optimization and updates.

With regards to reliability, I am not aware of the drawbacks. But dont take my word for it. This sounds like a question that LPurvis will love to answer :)

Did u read the help on this?

Suspends data processing, enabling the Microsoft Jet database engine to complete any pending tasks, such as memory optimization or page timeouts (Microsoft Jet workspaces only).

The Idle method allows the Microsoft Jet database engine to perform background tasks that may not be up-to-date because of intense data processing. This is often true in multiuser, multitasking environments that don't have enough background processing time to keep all records in a Recordset current.

Usually, read locks are removed and data in local dynaset-type Recordset objects are updated only when no other actions (including mouse movements) occur. If you periodically use the Idle method, Microsoft Jet can catch up on background processing tasks by releasing unneeded read locks.

Specifying the optional dbRefreshCache argument refreshes memory with only the most current data from the .mdb file. The dbForceOSFlush argument forces pending writes to .mdb files as part of the CommitTrans method.

You don't need to use this method in single-user environments unless multiple instances of an application are running. The Idle method may increase performance in a multiuser environment because it forces the database engine to write data to disk, releasing locks on memory.

Note You can also release read locks by making operations part of a transaction.

Im off out now, be back later on in the day.
Andy BrownAuthor Commented:
Thanks Rockiroads - that's some really good info (as always).
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Unfortunately, the Help file only gives one example ... thus not really explaining how and where  to use this method.  

There are soooooo many things that can affect speed in a network environment, starting with the speed of the network itself and of course the actual design of the application.

Andy BrownAuthor Commented:
Thanks for your help on this one - sorry for the dealy in getting back to you.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now