filename and path of linked ole file in blob field

[Rühmann, Günther]

hello,

I have an application with frontend Access 2000 and SQL Server 2000 als
backend.
One table contains a blob field that is filled with linked ole objects.

As I believe the filename and path of the file are stored in the blob field
instead of data .

Now, I need to push all these files from filesystem into a new blob field
with file data embedded.

Does anyone know a way how to move the files (paths must be in blob, but I
cannot access them) into a new blob programmatically ?

Best regards
Guenther

 

[Rühmann, Günther]

Hi I thank you very much for your respond. But it does not really help -
my English is not so perfect .....

What I mean is the reverse way. Not files themselves but links to the files
are stored in an OLE field. I´d like to loop though all records of that
table, get filename and path of the linked file and write that file -
embedded - into a new table. I found some code to write a file that way.
But I am looking for a way to extract filename and path to the linked files.

Regards
Guenther