How to store a file a OLE field ?!?

[Tom]

Hi

I'd like to store a bunch of files in an access database. Each file has to
be written in a new record (binary data format). In a second step, the files
should be extracted again. How to do?!?

Tom

 

[TC]

Why not store the files >as files<, and just store their names in the
database? You would not even have to save their paths. You could put them in
the same folder as the database. The code could determine that folder (using
currentdb.name or somesuch), add the file >name< (from the database record),
then use the VBA Open statement to open the file & read its data.

HTH,
TC

 

[André]

I have the same problem. Have you fixed it.