Aa above, download still failed. Can some post it in reply?

Assumeded that you have a table called ImageData with ImageNo varchar(50),  Data(Image) Fields

  Dim mstream As ADODB.Stream

  Dim rsDocumentAs ADODB.Recordset

   Set mstream = New ADODB.Stream

   mstream.Type = adTypeBinary

   rsDocument.Open "Select...

In Image(Blob) Data Type you can put any data, pdf, word, gif, your own class object into the database table field.

Using ADODB stream to load the object into field:

  Set...

Regardless you have compressed the images to smaller file size, the problem will remain in long run, if scanning is going to be on going, database will eventually grow back...

Please check your permission rights first for the crashing problem.

Another way to call the external application is through COM object. COM object will do what needed to be done....

I do agree with DALEC on the storing images in Database, it can be slow. A few GB Data is not a problem.

Step 1 : Create a table with...

Thanks for the XMLSPY option, we only have one license purchased.

Perferly with VB/SQL and not using the XMLSPY and third party application.

quote:

---

I use XMLSPY. Although its not code itself, it makes generating it easy. They have a demo version. Download it and see...