Displaying Oracle Blobs within Access

[tpsmith]

Hi

I am using an Oracle 9 database and various versions of Access 2000, XP & 2003. I cannot seem to find a way of displaying a JPG or BMP on a report or a form within Access that is held in a Blob field within the Oracle database. I get a blank white box with nothing appearing. I am using Linked tables using Oracle ODBC drivers and I have also used Microsoft ODBC drivers.

I would be grateful of any assistance with this.

Thank you.

 

[xlbo]

Your question is perfectly valid here but you may get more responses if you post in one of the Access Specific fora (there are 4 or 5 of these for different subsets of MS Access)

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[tpsmith]

Thanks, first time on here and not found all of the forums as yet.

 

[xlbo]

No probs - hope you have some luck. As I said - your question is perfectly valid here - it's just that most of the Access gurus will be watching their fora rather than this one (they sometimes answer questions here as well but not that many Access questions tend to get posted here)

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question