I was wondering if anyone could help me with this problem.

I have set up an ACCESS database which has a table (Table X) where one of the fields contains a text file stored as an OLE Object.

I have also created a VB front end that connects to the ACCESS database, cycles through each record in table X and creates a directory for each.

What I need to do is to be able to copy the OLE Objects in the ACCESS database to the corresponding directories that the VB app. creates. I want to do this within the code just after the ddirectories have been created

I want these text files to embedded in the database because there will be 100's of them and I plan to hand over this app to some inexperienced IT users. (I dont want any files being lost/modified)

Any help would be appreciated.

Thanks

- Mark