Attachments in Access

[JP Martinez]

I have a database where among several functions I use it to enter memo notes
and such - I would like to be able to
attach files to this form. Is there a way?

Any ideas will be appreciated

thanks

-Pierre

 

[Larry Linson]

You can, with some VBA code, store various kinds of document files in either
as OLE Objects or as Binary Large Objects (BLOBs) in OLE Fields. The imaging
examples at http://accdevel.tripod.com show how to do that for image files,
but the approach will be the same for other types.

An efficient way, also illustrated in the example, is to just store the path
and filename in the database, and leave the file external.

Larry Linson
Microsoft Access MVP

 

[JP Martinez]

Thanks -leaving the files externally makes sense

thanks

-Pierre