Attachment Field Does it Bloat Database

[cjman]

I was thinking of creating a table with the new attachment field. I want it
to hold photos. Does this field bloat the Database?

 

[Fred]

Haven't tried it 2007 yeat, but for everything up through 2003, if you insert
it as an OLE object it bloats like crazy and behaves badly.

You need to store it outside of the db, just put the link to it into a text
field and use programming etc. to use it (which is to display it in a form or
report)

If "Attachment Field" is a new Access 2007 term, my answer is irrelevant for
you.

 

[cjman]

It is for 2007.

Haven't tried it 2007 yeat, but for everything up through 2003, if you insert
it as an OLE object it bloats like crazy and behaves badly.

You need to store it outside of the db, just put the link to it into a text
field and use programming etc. to use it (which is to display it in a form or
report)

If "Attachment Field" is a new Access 2007 term, my answer is irrelevant for
you.