<div>
Sorry for the dealy. We encountered some other problems, we had to solve first.<br />
<br />
We link to the tably via ODBC. The table of all 'normal' fields are visible.<br />
The BLOB-Field is displayed as 'BLOB'<br />
It is just ASCII-text in the field.<br />
<br />
I want to read the data via a recordset. Once I got the value I want to save it to a different table.<br />
Need more info?
</div>


Sorry for the dealy. We encountered some other problems, we had to solve first.

We link to the tably via ODBC. The table of all 'normal' fields are visible.
The BLOB-Field is displayed as 'BLOB'
It is just ASCII-text in the field.

I want to read the data via a recordset. Once I got the value I want to save it to a different table.
Need more info?

<div>
<div class="content wysiwyg-content">
In Access we need to extraxt a string from a Firebird BLOB-field.<br />
The table containing the BLOB-field is linked over ODBC.<br />
How can we extract the pure text?
</div>
</div>


In Access we need to extraxt a string from a Firebird BLOB-field.
The table containing the BLOB-field is linked over ODBC.
How can we extract the pure text?

Read BLOBS from Firebird per ODBC-Connection

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.