USING BLOBS in Access

[a_20120]

I found a module which is able to read and write the BLOBS in Access, but I am having problem using that module on my database, so kindly request help on that, and I hope this time I get the answer
See the attachment

 

[modest]

You are missing the table where the blob will be stored: [tblBLOB]

Fields:
FKID (long Integer)
FKTable (Text-255)
BLOBDesc (255)
FileExtn (5)
BLOB (OLE Object)


You call it with:
InsertBLOB(rst!ST_ID, "tblDataEmployees", "Employee Pic", strFile)

This function returns a boolean value that describes if the BLOB was successfully stored and therefore cannot be stored to a OLE Object in your [Students] table.

 

[modest]

See Attachment. Note, I added the table and changed the return type on the function. The BLOB is being stored in two tables, which is not advised for best performance.

If I were you I would reset InsertBlob to return a boolean, but modify the function to store in your STUDENTS table. I just didn't want to do your work for you.

Study the code and make changes as you see fit.

 

[a_20120]

Thanks Modest for replying,
I know that there is needed another table named BLOB and some field within that table, but I dont like to use the photo in a separate table, Some one did that, and I put here may help others and be useful too.
PROB:
also if possible have a look at the attachment, because I dont know how to read the BLOB from the table STUDENT on From frmStudentSearch.
Thanks