Houston:

I replied to you because of the 8000 bytes limit you mentioned.

I don't think it's fair to assume the originator's documents will be automatically compressed (none of my clients use automatic compression except for email attachments and a few specialized applications).

---------------------------------------------------------------------------
> Also - General Field, were these linked or embedded? And if editing was not done in situ would a Memo (binary) field have worked eqally well?
---------------------------------------------------------------------------

The main application has created over 50,000 documents a year for the past 4 years. Linking was not an option because LAN Services didn't want us to put that many file on their network (not to mention it's a bad idea to have so many files in a folder). We tried embedding the document in a General field but this idea was quickly dropped due to redisplay problems (the document stored in the General field is not an exact image of the document we generated) and disk space requirements.

We finally decided to store the compressed letters in a memo field. Storing uncompressed documents in a Memo field works as well except it requires about 8 times as much disk space. We compressed the documens because we wanted to use 1 table per year to store the letters.


Daniel