[AccessD] Grab Filenames

    My earlier testing of John's code (ref my previous message dated 20-May-2003) was based upon setting  .FileType as msoFileTypeAllFiles (commenting out the line related to .FileName).

    On further testing of this code, certain relevant findings are given below -

    (a) If the line [ .FileName = "*.mda; *.mdb; *.mde; *.ldb" ] is  enabled (instead of the one related to .FileType) the result of search count is zero.
        Reason - No match is possible for above type of string.
        Solution - Use homogeneous string without delimiters.e.g.
                         .FileName = "*.mdb"

    (b) Starting letter of folder name does not matter.

    (c) If any of the file names has special characters(quite often the case with web documents), there is an error message reg syntax error, the loop is exited and no further information gets inserted in the table. Sometimes this problem occurs for date fields as well. Moreover, the cursor remains stuck indefinitely in the hourglass mode.
        Reason - SQL string does not get concatenated properly.
        Solution - Avoid use of SQL string as the likelihood of unforeseen syntax complications can never be completely ruled out. In lieu rst.Add method could be considered. 
    Note - As an experiment, the code was run after modifying the SQL so as to insert "A" for FilePath and "B" for FileName fields only, ignoring the date fields. There was no problem. Approx 7,000 files were found in all (main folder plus subfolders).The numbers shown in the message box tallied with the records appended to the table.

    John may like to modify the code suitably, addressing the points brought out above and distribute the revised version. While doing so, he may consider incorporating folder browsing feature so that there is no need for editing code module (for starting folder path).

Regards,
A.D.Tejpal
--------------
  ----- Original Message ----- 
  From: Roz Clarke 
  To: 'accessd at databaseadvisors.com' 
  Sent: Thursday, May 22, 2003 14:32
  Subject: RE: [AccessD] Grab Filenames


  This may be the case, but wouldn't explain why Charlotte got 0 files
  returned in her search...

  -----Original Message-----
  From: Ron Allen [mailto:chizotz at charter.net] 
  Sent: 21 May 2003 17:47
  To: accessd at databaseadvisors.com
  Subject: Re: [AccessD] Grab Filenames


  Is there a limit to the number of directories and 
  subdirectories that can be searched/found this way? There 
  used to be some absolute limits to the number of 
  directories in the root and other stuff... I'm wondering 
  if there is a limit, artificial or not, being hit here. 
  Does it by chance find "exactly" 128, or 256, or 512, etc. 
  folders/files before choking?


  >-----Original Message-----
  >From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
  >Sent: Wednesday, May 21, 2003 11:50 AM
  >To: 'accessd at databaseadvisors.com'
  >Subject: RE: [AccessD] Grab Filenames
  >
  >
  >Interesting fact just spotted... All of the directories
  >it doesn't look in
  >are those which come after M in the alphabet and are 
  >coming from the root
  >folder, and their sub-directories.
  >
  >It's as if it gets so far and just stops. Any way to
  >troubleshoot what it's
  >doing? Why it's breaking?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030522/9a3df1a7/attachment-0001.html>