Member Avatar for paoi00

I wish to save and retrieve image in access 2007.
in our search module , if employee number typed, it could retrieve all information of the employee including the image saved in database(?) if this can be happen?

  • 2 Contributors
  • 5 Replies
  • 203 Views
  • 59 Minutes Discussion Span
  • Latest Post Latest Post by Begginnerdev
Member Avatar for Begginnerdev

There are two ways of doing this.

You can save a path to the image

OR

You can save the image into the database (As a blob)

Member Avatar for paoi00

You can save the image into the database (As a blob)

how to do that? can you give me a code about that? i'm such a beginner in this matter. thank you~

Member Avatar for Begginnerdev

Here is Microsoft's Article on how to do so.

Member Avatar for paoi00

i'm using access 2007 . :3

Member Avatar for Begginnerdev

You are not asking for vb.net related material, just Access help?

If so, I can flag your post to get a mod to transfer it to the correct forum.

Or perhaps I am misunderstanding...

From my experience, it's easier to define a field for a string that contains the path to the file.

This will keep the database from having to pour over Blobs to retreive data.

This can be done by simply performing an insert.

"INSERT INTO table(column1,column2,column3) VALUES ('name','address','C:/Users/paoi00/myPic.jpg')" 'Of course you will change the path to the true path.

What language library are you using?

Jet, OleDB...?

Edited by Begginnerdev
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.