>>Archiving records or going to SQL Server seems like an inevitable conclusion at some point.
>>
>>There are two ways I have used to Archive – the simple way was to dump to a CD. Creating a separate database was another way. There are lots of unknowns.
>>
>>As Cindy pointed out if this can be done with a simple change of structure and will suffice then that is the way to go. It might be a good temporary or permanent fix depending upon what is going on.
>
>A very temporary solution if the number of incoming records (or net gain on records if deletions are permitted) is big enough. I had to go to SQL Server for one of my main apps that dealt with individual transactions as we generate over 60 thousand a day in that particular table. When the file was at about 1.5Gb I did the change of code (not too difficult) and we switched. The original design we were told to do was for less than a thousand records a day. You have got to trust your customers as they know their stuff, don't they.

LOL! Yes, the customers! :)