Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Hard Drive Folder Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mcp6453 - 13 Jan 2008 15:47 GMT
Like many here, I have quite a few retired hard drives with archived and
valuable data of all sorts. As time goes on, it becomes increasingly
difficult to find files. Is there a utility for XP that will start at
the root of a hard drive, scan the tree, and output the results to a
text, Excel, or Access file? It is easy to attach the drives to a
computer with an IDE-to-USB converter.
PD - 13 Jan 2008 16:24 GMT
> Like many here, I have quite a few retired hard drives with archived and
> valuable data of all sorts.

Every time I retire a drive, I take my "valuable data" with me to the
new drive.  I've got stuff on this drive from 15 years ago.

> Is there a utility for XP that will start at
> the root of a hard drive, scan the tree, and output the results to a
> text, Excel, or Access file? It is easy to attach the drives to a
> computer with an IDE-to-USB converter.

http://www.karenware.com/powertools/ptdirprn.asp
DL - 13 Jan 2008 16:35 GMT
There are numerous Desk Top search apps including the MS one

> Like many here, I have quite a few retired hard drives with archived and
> valuable data of all sorts. As time goes on, it becomes increasingly
> difficult to find files. Is there a utility for XP that will start at the
> root of a hard drive, scan the tree, and output the results to a text,
> Excel, or Access file? It is easy to attach the drives to a computer with
> an IDE-to-USB converter.
mcp6453 - 13 Jan 2008 16:57 GMT
The hard drives are not installed in a computer. They are shelved for
archiving purposes. I don't see how a desktop search utility will be of
any benefit.

I tried Simple Disk Catalog, which does a great job, but after the
search, clicking on a column header does not sort the data in the
column, which makes browsing the search results tedious.

Karen's utility is great for printing a single drive, but its cataloging
function seems to be limited to exporting to a .txt file.

Thanks for the suggestions, though.

> There are numerous Desk Top search apps including the MS one
>
[quoted text clipped - 4 lines]
>> Excel, or Access file? It is easy to attach the drives to a computer with
>> an IDE-to-USB converter.
rod - 13 Jan 2008 22:26 GMT
I use one called "Cathy Disk cataloguer" and find it marvelous,
it logs every folder file in the tree hiearchy.
the only cost, one has to send a postcard to the author's daughter.
I have had it for years so you will have to Google for it.
It does a full CD rom of archived data in a few seconds,
I download the results to an MSWorks flat file database
for easy searching.
Good Luck.

> Like many here, I have quite a few retired hard drives with archived and
> valuable data of all sorts. As time goes on, it becomes increasingly
> difficult to find files. Is there a utility for XP that will start at the
> root of a hard drive, scan the tree, and output the results to a text,
> Excel, or Access file? It is easy to attach the drives to a computer with
> an IDE-to-USB converter.
rod - 13 Jan 2008 22:32 GMT
It was a bit hidden away, but found it here...
http://www.mtg.sk/rva/

> I use one called "Cathy Disk cataloguer" and find it marvelous,
> it logs every folder file in the tree hiearchy.
[quoted text clipped - 4 lines]
> for easy searching.
> Good Luck.
mcp6453 - 14 Jan 2008 01:52 GMT
Thanks, Rod. I'm playing with it now. It's obviously a well written
little utility.

> It was a bit hidden away, but found it here...
> http://www.mtg.sk/rva/
[quoted text clipped - 7 lines]
>> for easy searching.
>> Good Luck.
rod - 14 Jan 2008 02:11 GMT
From memory, it had its quirks,
I remember having a few frustrations setting the fields,
but when you set up to choice, its a breeze,
A bit like all software I guess.

"mcp6453" <mcp6453@gmail.com>
> Thanks, Rod. I'm playing with it now. It's obviously a well written little
> utility.
John W. Vinson - 14 Jan 2008 00:04 GMT
>Like many here, I have quite a few retired hard drives with archived and
>valuable data of all sorts. As time goes on, it becomes increasingly
>difficult to find files. Is there a utility for XP that will start at
>the root of a hard drive, scan the tree, and output the results to a
>text, Excel, or Access file? It is easy to attach the drives to a
>computer with an IDE-to-USB converter.

You can use the DIR() function recursively in VBA to construct such a list
(writing to a table). Allen Browne has some sample code at

http://allenbrowne.com/ser-59alt.html

Amusingly, this is a good example of "what goes around comes around"; Allen's
credits are

Provided by Crystal (Microsoft Access MVP), April 2007. Based on code by Allen
Browne, adapted from a Usenet posting by Albert Kallal (Microsoft Access MVP.)

So from Allen to Albert to Crystal to Allen...!

            John W. Vinson [MVP]
Dirk Goldgar - 14 Jan 2008 03:08 GMT
> So from Allen to Albert to Crystal to Allen...!

Tinkers to Evers to Chance?

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

John W. Vinson - 14 Jan 2008 03:19 GMT
>> So from Allen to Albert to Crystal to Allen...!
>
>Tinkers to Evers to Chance?

Double play, retires the side, Access MVP's still ahead by 4.

            John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.