I would generally use a table to store logged information, this allows you to find what you need quickly through a query. If you decide to use text files, you should just append onto the end of a file instead of having many text files.

Bob

>Back to basics...
>
>I am designing a program to log a lot of certain information.
>
>A memo field would do the job, but I'm wondering if it would be better to store the information in a .txt file. The name of the .txt file can be kept in a table with the date and user name so that it is easy to find.
>
>The advantages of the .txt approach are:
>
> - The information is easy to find.
> - The problems with Fox table size limitations is avoided.
> - Memo bloat problems avoided.
>
>The disadvantages are:
>
> - The chosen directory gets filled with lots of files, most of which are less than 1kb in size (some are bigger).
>
>Any thoughts on which approach is better?
>
>Or other approaches?
>
>Cyril