Question Is it Possible to store photo on Access database

[tresehulyo]

Is it Possible to store photo on Access database

 

[alander]

yes you can,

you have to parse the header, store the file in a variable defined "as bit" and put it in an OLE object field in access.

 

[tresehulyo]

can you give link of example

 

[Tom]

Storing photos in a database can be done but is a bad idea.

Photos take up a lot of space and every time you update a record that contains a picture; regarless if you updating the picture field itself or another field within the same record, the database will create a completly new copy of the record - essientially doubling the size of the record within the table every time you update it. The database size quickly grows and needs maintaince to regain the space back.

It is much more efficient to store the picture in a specified directory such as a local or shared network folder and then just keep the filename and path in the database record