Folder Scanner - with ADODB - written in REALbasic 2007 r2 - Trial - for Windows XP sp2

This version of Folder Scanner has been built using ADODB connections to MSAccess.
This release is just a copy of the Valentina version.

After trialing a number of automated drive indexing utilities (Like Google Desk Top and Windows XP Indexing)
that seemed to use far too many of my CPU resources and seemed to slow my computer down. 
I was spending more time making sure they were NOT running than actually using them.

I also wanted to have a fair go at discovering:

How far I can could get with REALbasic 2007 r2
How intuitive is the interface.
How we use existing databases and com objects.
How stable is the REALbasic IDE. 
How close the REALbasic language is to VB6. 
How the help files interacted.  Including the Quick Start, Users Guide, and Users Manual.
How regular are the product releases.
How much does REALbasic cost.
How good is the support from REAL Software and the Community Forums.


This is my third application in REALbasic. 
I started from the FolderScanner with Valentina 2 hours ago.

Yes, things will be missing and I'm sure everything can be executed in a more efficient manner. 
All will come as a matter of time and experience with REALbasic.

I just wanted to prove how much I could accomplish in a relatively short amount of time.

My Overall Experience with ADODB so far:

Just too easy.  Less than an hour to make the changes.

--------

I've created a working application that could be useful to any who care to investigate and use. 

I offer the source in good faith as a starting point only.
Feel free to use my code and layout as you see fit.
Feel free to change the app and please be sure to share enhancements and code with the rest of us in the REALbasic and Valentina world.
Finally, be sure to give credit where credit is due and DON'T claim this exact application as your own.


Contains example of:
     This is a coding sample for the following:

 Controls:
     Window, TabPanel, ListBox, StaticText, PushButton, EditField, and Thread.
     Includes form resizing.
 
 Coding:
       Subroutines, Functions, Database Connectins and SQL Queries, Classes, Properties, Methods, and Modules.
     FolderItem, Item and TrueItem,  SelectFolderDialog, Threading, Shelling, Error Trapping, Do Loops, Constants, and Enums.
     ADODB connectsion
.

      
Folder Scanners with ADODB Initial Graphical User Interface

A screen shot of the initial Folder Scanner Graphical User Interface where you can:

Choose Folder and Start - Opens a Select Folder dialog where you can select a single folder. 
Once the folder is selected Folder Scanner will begin scanning the folder and sub folders for files
and write each File Path and File Name to its database.

You'll be able to watch its progression as the the Folder and File Names and File Count is displayed.

Use the clear button to clear the list box.
You'll also be able to stretch the form at any time.

    Folder Scanners with ADODB Search Database Tab.

A snapshot of Folder Scanners Search Database tab where you will be able to:

You can enter search criteria for the Folder Path and the File Name.
Use the * buttons to clear the text box contents.
Use the Search DB button to begin searching the database.

Use the SQL text box to copy the Valentina Database SQL query into the clipboard.
View the results of the query in the list box.
Use the Clear button to clear the list box.

Use the Open Containing Folder to open the files folder in Windows Explorer and highlight the file for action.
 

Folder Scanners FolderScanner with ADODB.zip download file contents.

Please be sure to run ANY download from ANYWHERE thru your virus protection software. 
Some virus protection software is automated, some are not.

Place nice constructive comments here

These are some nice comments about what I've learned over the last five days of REALbasic 2007 r2 research.

 

Some ideas regarding future enhancements

These are some nice comments about what I could add to the Folder Scanner Project.