Attachment data type makes table too big 1

[LARiot]

Hi. Any help is appreciated.

I have two tables in my database that use the attachment data type as one of the fields/colums. The problem is that every time an attachment is added the size of the database increases by the size of the attachment. This quickly turns the database from a 1 mb file to 50 MB file. The whole point of using attachments (as opposed to OLEDB) is for the database not to increase in size.

Does anyone have an idea why it's increasing so much?

Thanks in advance.

-Nima
"Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

 

[LARiot]

BTW, thanks again for all the help, especially MajP. The result of this that the database went from 53MB (with only test data) down to 2.4 MB. Without this modification it would've hit the 2GB limit in no time.

-Nima
"Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor

 

[MeldrethMan]

Hi LARiot

This looks just what I need to solve the same problem but I'm getting errors using your code, first for me.ImagePath (Method or datamember not found) then for With Application.FileDialog(msoFileDialogOpen), (-2147467259 Automation error).

Bit behind you on expertise sorry, and must be missing some things that are obvious. It would be a great help if you could explain the steps in a bit more detail. I got as far as inserting an unbound image into my form, then adding your double-click procedure.

 

[MajP]

I recommend you start a new thread and be specific on what you want and how you want it to work. LARiot had some very unique requirements that complicated the design. He was trying to change the bound field of an image control at run-time. You may need little or no code depending on what you want.

 

[MeldrethMan]

OK, thanks. I did start a thread but in the Forms forum, then found LARiot's here. In case it should be here I'll start a new one with exact details of what I need.

 

[LARiot]

Imagepath is a field/column in my table. Since the form's record source is pointing to that table, I can use it in my code.

-Nima
"Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor