Hi Friend,

In order to use MS access Database,you have to create the DSN connection. Follow these steps:

1. Open Data Sources (Start->Control Panel->Administrative Tool->Data Sources(ODBC)

2. Open User DSN tab
3. Add a user DSN
4. Select Microsoft Access Driver(*.mdb)
5. Select database name and Create the DSN name (e.g emp)
6. Click "Ok"

Then create a table Image(ID(Number),image(OLE Object)) and try the following code to insert and retrieve image from Access database:

import java.io.*;
import java.sql.*;
class AccessDatabase{
public static void main(String[] args) {
try{
String url="jdbc:odbc:access";

File file=new File("c:\\barbie.jpg");
FileInputStream in=new FileInputStream(file);

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access");
PreparedStatement ps = con.prepareStatement("INSERT INTO Image(ID,image) VALUES(?,?)");
ps.setInt(1,1235);
ps.setBinaryStream(2,in,(int)file.length());
ps.execute();
ps.close();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT image FROM Image where ID=1235");
if(rs.next())
{
InputStream fis1;
FileOutputStream fos;

fis1 = rs.getBinaryStream("image");
fos = new FileOutputStream(new File("accessImage.jpg"));
int c;
while ((c = fis1.read()) != -1)
{
fos.write(c);
}
fis1.close();
fos.close();

}
System.out.println("Image in inserted and created successfully");
rs.close();
stmt.close();
con.close();
}
catch(Exception e){
System.out.println(e);
}
}
}
Thanks