hi. I&#039;m trying to transfer a picture file into another database. My problem is that whenever I try doing this, a "type mismatch" error always occur. why is that? below is a sample of my code:<BR><BR>Set db = Server.CreateObject ("ADODB.Connection")<BR>db.Open ("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + "c:ojtphotobank empDb.mdb")<BR><BR>Set db2 = Server.CreateObject ("ADODB.Connection")<BR><BR>set conn = db.Execute ("Select * From temp Where [id] = CInt (&#039;"& occur &"&#039;)")<BR><BR>pic = conn ("file")<BR><BR>if type = "picture" then<BR><BR>db2.Open ("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + "c:ojtphotobankphotobankDb.mdb")<BR><BR>db2.Execut e ("Insert Into picture ([file]) Values(&#039;"& Pic &"&#039;)")<BR><BR>db is the file where the said file can be found. db2 on the other hand is its destination database.