Can anyone tell me if you can compress a visual foxpro 5/6 datafile and still interact with it in real time. I have created 12 datafiles all around 2 gig in size but would like to make them into one file for searching. Is there maybe another operating system i could use instead of Windows?

I have seen several products similar but they must be written in C. They allow very quick searches to take place and are accessing the same amount of records but the file size is less than 2 gig.

I thought that Foxpro was the best language to use for minipulating data!

Anyone got any ideas

Regards

Gareth.