By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Disc catalog to Access table

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.