>Walt
>
>In the same situation we moved as many customers as possible to SQL Server which does not have this constraint. SQL Server has 2K page sizes for text and image fields, this may not be great depending how big your pdfs are.
>
>For other customers we created 500 folders and saved the pdfs to a folder by something like [h]+alltrim(str(recno()%500)) which means you'll have 400 files per folder. However, this can cause *very* significant disk fragmentation.
Hmmm... Basiclaly, I like the idea, but in the expression
recno()%500, recno() can change (namely, if you delete and pack). If you use integer primary keys - of the sort that doesn't change - I would use those, instead. Otherwise, create an additional field just for this purpose. Or just keep a 2-letter prefix as part of the stored filename.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)