Option Explicit Dim b As ADODB.Recordset Dim c As ADODB.Stream Dim conn As New ADODB.ConnectionPrivate Sub Command1_Click() conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1.mdb;Persist Security Info=False" conn.Execute "create table a (Str longbinary)" End SubPrivate Sub Command2_Click() Set b = New ADODB.Recordset Set c = New ADODB.Stream c.Mode = adModeReadWrite c.Type = adTypeBinary c.Open c.LoadFromFile "D:\ss.JPG" b.Open "select * from a", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1.mdb;Persist Security Info=False", adOpenDynamic, adLockOptimistic b.AddNew b.Fields.Item(0).Value = c.Read() b.Update b.Close Set b = New ADODB.Recordset b.Open "select * from a", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:1.mdb;Persist Security Info=False", adOpenKeyset, adLockOptimistic MsgBox b.RecordCount b.MoveLast c.Write (b.Fields.Item(0).Value) c.SaveToFile "d:\aa.JPG", adSaveCreateOverWrite Picture1.Picture = LoadPicture("D:\aa.JPG") End Sub
Dim b As ADODB.Recordset
Dim c As ADODB.Stream
Dim conn As New ADODB.ConnectionPrivate Sub Command1_Click() conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1.mdb;Persist Security Info=False"
conn.Execute "create table a (Str longbinary)"
End SubPrivate Sub Command2_Click()
Set b = New ADODB.Recordset
Set c = New ADODB.Stream
c.Mode = adModeReadWrite
c.Type = adTypeBinary
c.Open
c.LoadFromFile "D:\ss.JPG"
b.Open "select * from a", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\1.mdb;Persist Security Info=False", adOpenDynamic, adLockOptimistic
b.AddNew
b.Fields.Item(0).Value = c.Read() b.Update
b.Close
Set b = New ADODB.Recordset
b.Open "select * from a", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:1.mdb;Persist Security Info=False", adOpenKeyset, adLockOptimistic
MsgBox b.RecordCount
b.MoveLast
c.Write (b.Fields.Item(0).Value)
c.SaveToFile "d:\aa.JPG", adSaveCreateOverWrite
Picture1.Picture = LoadPicture("D:\aa.JPG")
End Sub