You could get a list of all mdb files within a given directory and all
subdirectories via a script like this:
<cfset searchin = arraynew()>
<cfset searchin[1] = expandpath("")>
<cfset x = 1>
<cfoutput><cfloop condition="x lte arraylen(searchin)">
<div>#searchin[x]#</div>
<cfdirectory action="list" name="rssearch"
sort="name" directory="#searchin[x]#">
<cfloop query="rssearch">
<cfif ListFind(".,..",rssearch.name)>
<cfelseif listlast(rssearch.name,".") is "mdb">
<div> #rssearch.name#</div>
<cfelseif rssearch.type is "dir">
<cfset temp =
ArrayAppend(searchin,"#searchin[x]#\#rssearch.name#")>
</cfif>
</cfloop>
</cfloop></cfoutput>
Of course, this only helps if the file is within a directory path which is
accessible to CF within your sandbox ( if any ) and cffile and cfdirectory
haven't been disabled.
hth
Isaac Dealey
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
> Yes. On Windows. But I don't have physical access to the machine the
> database is on.
> ----- Original Message -----
> From: "Candace Cottrell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, August 29, 2002 5:29 PM
> Subject: Re: find mdb
>> This may be a silly question, but are you on Windows and do you have
>> access to the Start--->Find--->Files or Folders?
>>
>>
>>
>> Candace K. Cottrell, Web Developer
>> The Children's Medical Center
>> One Children's Plaza
>> Dayton, OH 45404
>> 937-641-4293
>> http://www.childrensdayton.org
>>
>>
>> [EMAIL PROTECTED]
>> >>> [EMAIL PROTECTED] 08/29/02 19:49 PM >>>
>> How would I find the path to an Access mdb file? I know the datasource
>> name but I can't find that *&$*#& file!
>>
>>
>>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
