Hi,
I would save the BLOB objects out to the filesystem and
only maintain a table with the associated information,
including filepath, in your Access application.
The other way would be to use SQL server or MSDE as your
backend database in an Access project application. Then
you can use BLOBS.
HTH
Chris
>-----Original Message-----
>I have a trouble ticketing application that saves off
>attachments in an Oracle BLOB field. When it saves off
the
>binary information it places a text header of a User ID
>and a DateTime stamp.
>
>I want to take and parse out the BLOB headers into a
>seperate MS Access table with the header saved in a text
>field limited to 256 characters.
>
>For the first trial I have been searching for a way to
>parse the BLOB information into multiple text rows in
>Access just to get started but cannot find an effective
>example of reading in multiple rows of Oracle BLOB and
>saving off as many more rows of smaller MS Access text.
>
>.
>
|