Picture files store in MS Access Field

[chinhow]

Can someone tell me is it possible to save and view the picture file into and/or From MS Access?

I found it might can be done by setting one of the MS Access field as a OLE object datatype and that field would provide as a link to the particular picture file. IF this works

1. How do i insert a picture file into the Access field?

2. How do i link this picturebox to access field?

[Pirate]

Originally posted by chinhow
Can someone tell me is it possible to save and view the picture file into and/or From MS Access?

I found it might can be done by setting one of the MS Access field as a OLE object datatype and that field would provide as a link to the particular picture file. IF this works

1. How do i insert a picture file into the Access field?

2. How do i link this picturebox to access field?

You can save images to MS DB . I did it once in VB6 . I set the field datatype in the db as OLE obj .Let me see if I can play with it in .net !!!

[Edneeis]

http://www.edneeis.com/Code/ImExPortDB.htm

[Lunatic3]

But is it wise? to store images in an access database (or any database) at it's size grows big? isnt it better to store the link to images?

[Pirate]

Originally posted by Lunatic3
But is it wise? to store images in an access database (or any database) at it's size grows big? isnt it better to store the link to images?

If you want to save your images in secured place , then you must store them in db . The only problem is the size after all but you can compress the db within your app .

[Edneeis]

Also if you just have a link and the program is used on a network then you must make sure that the place the actual picture file is stored is accessible to everyone you uses your app (through a network share or something) which can be problematic.

[hellswraith]

Originally posted by Edneeis
Also if you just have a link and the program is used on a network then you must make sure that the place the actual picture file is stored is accessible to everyone you uses your app (through a network share or something) which can be problematic.

Could be problematic, but also could give you a lot more control. You can set up certain pictures in different folders, and assign roles access to those folders. This in turn will give you a finer grain of control to resources. Of course, this would only fit certain situations.

[Edneeis]

True, I guess it depends on your specific situation.

[Lunatic3]

What about the performance? Imagine working with DICOM3 images that are usually 20-100 mbytes each.

[hellswraith]

Performance is the big one. I would fight to keep images out of the db myself. Your going to have a lot of paging happening in the db, and that will KILL performance. But, some situations may require it, but I would try like hell to find a different way, unless only 2 or 3 people will be accessing the db.

[Edneeis]

I do this in a couple apps and as long as the pictures aren't too big it works great. I would however suggest using SQL server for this. Basically its just a big blob of binary to the database so if you keep the size down then its not much different than a lot of text.