Hi, As stated http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html
I have stored image using the following. CREATE TABLE files( file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, file_name VARCHAR(64) NOT NULL, file_size MEDIUMINT UNSIGNED NOT NULL, file MEDIUMBLOB NOT NULL); I can store and i can retrieve the image to local machine as a file. I NEED TO SHOW ALL THE FIELDS IN THE CRYSTAL REPORT. Thank you VIKRAM A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/