Can a db.property of dbLongBonary type be used for an image?

[swas]

Hello,



Is it possible to store an image as a database property?

Property type dbLongBinary seems to be for this, but not sure on usage.

Example:
obj.Properties.Append obj.CreateProperty("MyImageProperty", dbLongBinary, varMyImage)


Thanks for any comments.

swas

[CJ_London]

a) have you tried it?
b) why would you want to do it?

[swas]

Ajax,

Thanks for the reply.

Tried setting a property with an image stored in a table as an OLE type but errors out (Sorry don't have my normal Access where I am at the moment to get the error).

I just need to store a company logo. I could store in a single record table, or a binary table for images. As a property seems its correct place for a one-off image.


swas

[CJ_London]

Don't think I would consider it a property since it is more of a 'thing', object/file/whatever.

[swas]

Thanks for the response.

I'm not sure that answers the initial question though; usage example or if can't be done for an image.

I would think one-off db information lends itself correctly to a custom user property, even an image.

If not a property then how best to store a single image? A single record, single field table (Be it OLE or Attachment type)?

Note I prefer to keep things contained within one db file, so while a link to an external stored image file is an alternative it is not a preferred solution.

Thanks again.

swas

[CJ_London]

I suspect there is a limit to a property size. Had a quick look, only found this

https://support.office.com/en-us/art...8-98c1025bb47c

where a field property is limited to 255 chars

as to how best - depends how you are going to use it. could be in a picture control on a form, report or button, could be an ole object in a table. I often have a single record configuration table for example, but personally I prefer to keep images separate.

[swas]

Not sure where you drew that info from in the attachment. No of fields 255, or characters in a short text field type is 255.

Anyway I'll figure something out.

Thanks

swas

[CJ_London]

it's in the table section