How to store a file a OLE field ?!?

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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
 
Back
Top