Storing pictures

[fkheng]

Is it possible to store image or picture files in MS Access?

[Robby]

It is possible and is done without great difficulty, however I

strongly recommend against using this approach. It will blow the

size of your database more than you would expect, ie. you would

expect 10 JPGs of 100 k each would increase the DB by 1 meg, in

reallity it will increase the size much more. A better design would

be storing the images on disk and only save the file name in the

DB.

 

If you still perfer to save them in Access, let me know I'll point

you in the right diection.

[sizer]

robby is right,

but if you decide to store pictures in db you have explanation on

this Microsoft site

:D

[Robby]

If you want to do it using vb.net..... http://www.dotnetextreme.com/code/SavingImageIndatabase.asp

[fkheng]

would storing it in sql server 2000 be better? or still the same problem?

[mutant]

Doesnt matter what DB, its a bad practice and not recommended.

[fkheng]

ui see, just curious

coz i saw my friend store pictures in his database, so i thought it was something cool, but since yeah, not such a good practice as u said...

 

i'll just store the path then, thanks a lot!