MS ACCESS HELP

[md3]

i have an access table that stores images as memotype. it is a series of numbers.any one can help me restore it as a image again in vb 6.and one more thing i dont have an idea on how the data was saved since mdb was given to me.

any help would be appreciated..thanks

 

[AccessGuruCarl]

Strange...

Memo Fields are for text only....
Are they all numbers or mixed alpanumeric?

A few things to try.

1st.. Change the data type to OLE Object.
Open the table, if it says Package or Bitmap(instead of your numbers). Double click it, the image should open.

If its Long Binary... then 1 of a few things happened.
Someone renamed them to like a .txt file or anything for that matter that as long as it's not an image ext. Then must have read into a string and imported it.

Open notepad....
Paste the entire memo field and save it. Now try renaming the ext to .bmp or .jpg, try opening it.

If it worked great... If not, then I'd guess they encrypted the images, or used some other tool out there that converts the image to alpanumeric characters.

You may find that once the text is pasted into notepad, if you look carefully. The image might be staring you in face. Which if this is the case, someone has used a conversion tool, and I don't think you can convert it back. I've seen images like this in a few .info files.

Without knowing how it was imported(I'm Guessing" you may be out of luck. What about the guy that gave it to you, does he have any ideas on how it was inputted?
If you don't have any luck, and have a way of attaching it to a post, I'd love to take a crack at it.

Let me know how you make out...

By the way... You posted this in a VB forum... Not the Access forum, be careful posting in the wrong forums!

Good Luck

AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[SBerthold]

>Without knowing how it was imported(I'm Guessing" you may be out of luck

If it converts to an OLE field, and is a package, then you can use an OLE Container to show it. It should work in that case, though only under DAO.

If it is a picture object, then I'd use an ADO Steam object to get it into a PictureBox.

It may also just contain a link to a file, such as if it is in RTF format, which could then be done differently.

 

[md3]

im sorry if i posted this in wrong forum. i was doing it in vb6 so i posted in this forum..no luck on ways you give me.
by the way here is a sample memo

1082491240270452012351750130950960421002550712401082491240270452012351750130
9509604210025507124010824912402704520123517501309509604210025507124010824912
4027045201235175013095096042100255071240108249124027045201235175013095096042
100255071240108249124027045201235175013095096042100255071240108249124


any ideas???thanks