custom metadata field extraction

[krazymike]

I have code that indexes all the files in a folder and sub-folders,
and puts data about those files in an access database.

I'm extracting the common metadata (MS-Office generated), file system
stats, MD5, etc. What I'd like to add is the custom metadata that can
be defined and populated.

I'm using the DSOFile.OleDocumentProperties object now. I'd like to
use the .CustomProperties collection, but I can't think of how to set
up the database to handle this. I have no idea the maximum number of
fields that can be defined. I guess maybe I need another table just
for these? I don't know. Any ideas are welcome.

 

[krazymike]

I got it. Thanks for all your input.