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 Ill 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

 

[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...

ill just store the path then, thanks a lot!