Export af Ole-Object

If you dont get a solution with this then drop a comment and I will see if I can help you on the way.

Rather busy right now :o)

I still don't have a solution.

Please help !!!

I think I have some code at home which may be able to extract the files from the database. The only problem is that it may be necessary to remove a number of bytes (characters) from the start of the file before it will be recoognised as a JPG file. This is if you have put the file in the database through an OLE object such as MS Paint (on a form).

How have you putthe files in the dB?

Sorry, have been out a few hours.
The pictures have been imported from a Digital Camera. And are stored as BLOB's

Here is a link which explains how to extract a BLOB file from Access using DAO.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q103257&

The code I have is very similar to this.

have you looked at this hjbe?

Sorry not yet, I will look tomorrow :-)

Have tried it now, but i am a little stuck.
I presume its the WriteBLOB I have to use.
When I put in the name of the table and the field in the sentance as :

=WriteBLOB([phototable];[photo];"d:\photo")
it comes up with an error ?

Have you tried it ?

If you look at the example (copyfile) further down the page, you will see that T (table name) is actually a recordset.

(Set T = db.OpenRecordset("BLOB", dbOpenTable))


Yes I have tried it!

But you will also need to make routine which loops through the recordset and for each record in the recordset call WriteBlob.´

I'm rather busy at the moment, but if you can send my your database (or a small example) I will try and put something together for you this evening.

eksperten@NOSPAMsanthell.dk

remove NOSPAM

Hi Terry
I have sent you an example !
Thanks for now

hi hjbe
have you seen the eamil I sent yesterday?

Yes, I am looking at right now.
It seems that the problem with getting to see the exported pictures is not there on the original db.
So thanks very much, you earned the points

So you can see the pictures OK?

and thnk you too

Yes the pictures come out allright.