Picture in Database

[aransiola]

Someone to help me with a vb6 code that can save Picture into an access/SQL Server database. Presently i save the Picture Path as a string inside the database table but i want the actual picture to be saved as part of the table. What is the implication of saving picture inside access table? t.aransiola

[mbuller]

Not Sure on the implication or the how to do the above task... what are you trying to use this picture int he database for? I might have a few Ideas on how to accomplish the same thing without the hastle of figuring this out. Michael

[aransiola]

i want to save the picture inside the database because saving the picture using the picture filename, once the picture filename or pathname is tampered with the picture will not show on my vb form i have done this in vb.net 2003 and is working, is just that i have a vb6 application that i want to do the same thanks t.aransiola

[Dave Sexton]

Search for BLOB's at www.msdn.microsoft.com. I'd do it for you but I'm here on my mobile :( I've had the same question before and that's the answer I got.

[karansharma]

i dont know how to do it in vb but in vb.net if u want to store picture in Sql or access , u first have to convert ur picture in binary format , then store it in sql / access in [image] field. and to vice-versa to show in ur form.This is all u have to do to store pics in database. I think it works for u .