I am facing a problem in storing an array of integers to an OLE object field in the database, the used code for this action is listed below:
Dim oAccesss As New ADODB.Connection
Dim oRecordset11 As New ADODB.Recordset
oAccesss.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\DBS.mdb;"
oRecordset11.Open "Select OLEdata From Table1", oAccesss, adOpenKeyset, adLockOptimistic
Dim SS(10) As integer
For N = 0 To 9
SS(N) = rnd
.Fields.Item(0) = SS
Better yet to save Handles instead of ObjectIds,
see example how to save texts to the newly created database
make sure you change all file names in this project to suit
See attached project for more
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.