If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Attachment Field Does it Bloat Database
I was thinking of creating a table with the new attachment field. I want it
to hold photos. Does this field bloat the Database? |
#2
|
|||
|
|||
Attachment Field Does it Bloat Database
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" wrote: I was thinking of creating a table with the new attachment field. I want it to hold photos. Does this field bloat the Database? |
#3
|
|||
|
|||
Attachment Field Does it Bloat Database
It is for 2007.
"Fred" wrote: 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" wrote: I was thinking of creating a table with the new attachment field. I want it to hold photos. Does this field bloat the Database? |
Thread Tools | |
Display Modes | |
|
|