Disc catalog to Access table

[Thomas]

Greetings to all,
I would like to save the catalogs (disc tree) of various CDs to an
Access table then use the Treeview control to view the contents to find
files and so on at a later time instead of inserting disks in a CD.
I have a reasonable idea of the treeview control however, I have no idea
of how to read a CD into a table using VBA.
There may be a better way to accomplish this also.
Any help would be appreciated.

Thanks to all in advance
ThomasJ

[rkc]

"Thomas" <Vz******@Verizon.net> wrote in message
news:lr******************@nwrdny02.gnilink.net...

Greetings to all,
I would like to save the catalogs (disc tree) of various CDs to an
Access table then use the Treeview control to view the contents to find
files and so on at a later time instead of inserting disks in a CD.
I have a reasonable idea of the treeview control however, I have no idea
of how to read a CD into a table using VBA.
There may be a better way to accomplish this also.
Any help would be appreciated.

If you're not allergic to the Scripting Runtime library the FileSystemObject
is the easiest way to read an entire 'Folder' structure.

Methods to do the same using the VBA Dir function have been posted several
times in this newsgroup.

[Trevor Best]

On Mon, 16 Feb 2004 22:25:21 GMT in comp.databases.ms-access, Thomas
<Vz******@Verizon.net> wrote:

Greetings to all,
I would like to save the catalogs (disc tree) of various CDs to an
Access table then use the Treeview control to view the contents to find
files and so on at a later time instead of inserting disks in a CD.
I have a reasonable idea of the treeview control however, I have no idea
of how to read a CD into a table using VBA.
There may be a better way to accomplish this also.
Any help would be appreciated.

I have such an application and had no problem getting the tree and
files into the table, I have a problem with TreeView, basically I
haven't got a clue about it, sounds like the basis of a symbiotic
relationship :-)

Use my first name @besty.org.uk to mail me (may take a couple of days
for a response now asI have a funeral to go to tomorrow and
travelling tonight).

--
A)bort, R)etry, I)nfluence with large hammer.