Hi, I have tried to findthe codes in VBto: - Upload and Thumbnails image and insert intoMS Access - View images from MS Access - view Images from MS Access into GridView cheers Francisco
http://www.jamiessoftware.tk/articles/handlingimages.html I believe storing and pullingImagesfrom a DB is compartively slower than storing their paths instead and storing all the images in a file system. Vikram DiscountASP.NET www.DiscountASP.NET
This is really not a good idea if you use MS Access. Images are stores as BLOB within the database, as a result, it makes the DB file very large. With MS Access, you run into all kinds of problem if the database file is too big. I recommend using SQL or store image on the file system instead. Bruce DiscountASP.NET www.DiscountASP.NET
Well as I had mentioned earlier that you could store the image source(paths) as one of your columns in your database table and have the image's stored on a file system. Vikram DiscountASP.NET www.DiscountASP.NET
Many thank for the advice. Now, If I change the database for MYSQL. Do you know what could bethe codes?
haven't try storing BLOB in mySQL, can't really tell you. Highly recommend you use MS SQL. Bruce DiscountASP.NET www.DiscountASP.NET
I've stored blobs in MySQL, but you don't get any performance increase (as vvsharma mentioned, it's usually the opposite; slower image rendering), and your database backups take longer (obviously). But if you must store images in a database, yeah, you definitely want to move away from Access. mjp DiscountASP.NET <SUB><SUP>http://DiscountASP.NET