[AccessD] Access 2007 Attachments

Hi Marty

Thanks Marty. That explains:

<quote>
By default, each field in a relational database contains only one piece of data. For example, if an address field contained more than one address, finding addresses would be difficult, if not impossible. So at first glance, attachments seem to break the rules of database design because you can attach more than one file * one piece of data * to a field. However, attachments do not break any design rules, because as you attach files to a record, Office Access 2007 creates one or more system tables and uses those tables behind the scenes to normalize your data. You cannot view or work with those tables.
</quote>

Except that A2007 will compress files that are not compressed by default, the file content itself will always be stored within the database file. Even though a single file is limited to 256 MB, users can easily bloat or explode any database file as this is limited to 2 GB. There will be no easy way around this.

So how useful is this?

/gustav

>>> martyconnelly at shaw.ca 03-01-2007 01:25 >>>
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.