Windows Search 4.0 interferes with application.filesearch

Application.filesearch Issue
You have a problem if you:
  • use Microsoft® Access 2002
  • installed Windows® Search 4.0
  • use application.filesearch in your code
You will soon find that Windows® Search 4.0 prevents application.filesearch. This is probably of no consequence to Microsoft since they released Microsoft® Access 2007 without the application.filesearch function.

The consequence may be huge to businesses and programmers still using Microsoft® Access 2002.

You may resolve this problem two ways.
  1. Rewrite your databases using vbDirectory or filesystemobject. Some resources for doing this:
    1. Replacing Application.Filesearch with vbDirectory for List Box Rowsource of Files (http://www.thegenericdatabase.com/2011/11/file-list-vbdirectory-vba-visual-basic.html)
    2. Downloadable sample database that uses vbDirectory to create file lists and also moves files. Available on my Google Docs page:  docs.google.com/file/d/0B5TehEdDbkHNNTRhMWMwODUtZmVlMC00NmM2LWFmNTgtZTM1NTE2Y2ExZjU3/edit?pli=1
    3. Instructions for downloading and opening my sample databases from my Googledocs page : docs.google.com/file/d/0B5TehEdDbkHNNTRhMWMwODUtZmVlMC00NmM2LWFmNTgtZTM1NTE2Y2ExZjU3/edit?pli=1
  2. create a shortcut on the Desktop to stop and start the Indexing Service whenever you wish.
Continue reading below to create a shortcut to stop and start the Indexing Service.



Creating a Shortcut to the Indexing Service

To create a shortcut on the Desktop to control the Indexing Service:

Click on the Start button on the left bottom of the screen.
Click on Run from the Start Menu
In the text box that appears, type:    mmc
Select File from the menu bar of the Console Window that opens.
Select Add/Remove Snap-in from the drop-down menu
Select the Standalone Tab on the Add/Remove Snap-in Window
Click the Add button on the Add/Remove Snap-in Window
Select Computer Management from the Add Standalone Snap-in Window
Click the Add button at the bottom of the Add Standalone Snap-in Window
Select Local Computer using the radio button
Click the Finish button
Close the Add Standalone Snap-in Window
Close the Add/Remove Snap-in Window
On the Console Window, click the - sign  (minus sign) next to Computer Management to expand the tree
Click the - (minus sign inside a box) next to Services and Applications to expand the tree
Highlight (select) Indexing Service
With Indexing Service highlighted (selected), select File from the menu bar
Select Save As from the drop-down menu
Save the file to your Desktop so you can click on it when needed

Now you can keep the Indexing Service running but stop it when you need to work with your databases that use application.filesearch. When you are finished working, you can start it again.

Continue reading below for instructions on using the shortcut.


Using the Shortcut to the Indexing Service

Four simple steps to using the shortcut:

  1. Click or double-click the shortcut as per your computer setup.
  2. Select Action from the menu bar of Console Window.
  3. Select either Start or Stop as desired.
  4. Close the Console Window.
Be sure to let me know how this works for you.

Comments

Popular Posts