MartyConnelly
martyconnelly at shaw.ca
Tue Jan 2 18:25:45 CST 2007
You can have multiple file attachments to one attachment field in an accdb file such as a photo, a word document resume and a visio attachment. More info on attachments here. http://office.microsoft.com/en-us/access/HA012138521033.aspx From the object model in 2007, it looks like you do it from code this way but this is a guess DAO.Field2.SaveToFile "filename-string" DAO.Field2.LoadFromFile "filename-string" Martin Reid wrote: >Anyone done any messing about with Access 2007 attachments? Trying to see if anyone hasd coded anything or indeed is it worth the effort. > >Martin > > > >Martin WP Reid >Training and Assessment Unit >Riddle Hall >Belfast > >tel: 02890 974477 > > > > > -- Marty Connelly Victoria, B.C. Canada