>>>>We have a list of file names in a table and are attempting to append the AutoCad DWG files into the corresponding general field. The problem is that the append general command opens AutCad for every file in the list. After about 20 copies of AutoCad being opened, the machines grinds to a halt...
>>>>
>>>>How can we append an AutoCad picture to a general field without AutoCad being opened?
>>>>
>>>
>>>You can't - by the nature of a General field, it fire the OLE server application each and every time you manipulate the General field's content. The solution is to use a binary memo field to hold the data, and extract it when you need it, putting it back into the memo field when you're finished manipulating it, or deleting the extracted file if no changes were made.
>>
>>The reason we wanted to use the general field is that..
>>.. one user (the cad operator) could add the drawing to the data
>>.. while others, without AutoCad on their machine, could produce a report containing those pictures.
>>
>>Is this still possible with the binary memo approach? How would I load the file into the memo - would this be a FileToStr() type operation? Are there any alternative approaches of getting a DWG onto a report that your aware of?
>
>You'd move them either using FileToStr() and StrToFile(), or with APPEND MEMO/COPY MEMO. Since you could create instances of the file with unique names, several people could run AutoCAD against the content at once. And you're going to have to install AutoCAD on each system to print IAC - the General field relies on an OLE Server application, in this case AutoCAD, to handle the contents, including printing them, so you still need it on each station to deal with the .DWG files, unless you have another application that can handle .DWG files for you. There's no native OLE Server for .DWG other than AutoCAD that I'm aware of, at least there isn't a native one provided with Win98, WinNT or Win2K.

Once the image is appended into the general field then it can be used on screen, report, etc on machines that doesn't have AutoCad. We do that at the moment. We are just looking for a more automated way of loading the images.

I'm suprised theres not a way of supressing AutoCad in the same way as PaintBrush or PaintShopPro isn't opened when a bitmap is loaded. That is, it may be loaded in the background, but it is invisible to the user and following the append there is no sign of the program opening.