MS Access Data Type

[SillyMonkeyPro]

Hi

Could anyone tell me please.


Does the MS Access Attachment Data type cause Database Bloat?

Thank you all again

[Rudi]

Hope this helps to answer your question:

The Attachment data type, introduced in Access 2007, is very similar to the OLE Object data type in that you can use it to store complex data. However, unlike the OLE Object data type, you can store multiple attachments in a single record. These files are stored in a binary field in a hidden system table. OLE objects usually result in database bloat because the files are not compressed, and Access also stores a bitmap thumbnail of the embedded file that can often be larger than the original file. For the Attachment data type, Access compresses each file, if it isn't already, and uses the original file rather than a generated thumbnail to minimize the amount of database bloat.

Source: http://sourcedaddy.com/ms-access/unders ... types.html

[SillyMonkeyPro]

Hi

Thank you Rudi.

You have cast some light on my question