[AccessD] Grab Filenames

I didn't get a FoundFiles count with or without filetype, and I was
using "*.*" for .FileName.
 
Charlotte Foust

	-----Original Message-----
	From: A.D.Tejpal [mailto:ad_tp at hotmail.com] 
	Sent: Thursday, May 22, 2003 9:12 AM
	To: accessd at databaseadvisors.com
	Subject: Re: [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 <mailto:roz.clarke at donnslaw.co.uk>  
		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/477fcfbf/attachment-0001.html>