Using Foxpro 2.6 (DOS), we are encountering a file access error that we believe is connected to the size of one of our tables (1.1 gig – exceeds the foxpro limit). It is part of a legacy system that has 19 tables, many with multiple indexes (.idx’s, not .cdx’s). The other tables are each under 100mb (many under 10mb), so I don’t believe that they are causing the problem. The error does not crash the system, but does significantly slow down access to records – actually pausing the program for up to 5 minutes at a time, while the words “Record not available? Please Wait” scroll in a red box at the top of the screen. Reducing the size of the file has proven to be very difficult, if not impossible. How can we deal with this very large table without the file access delays?
