>I have a file that my FoxPro app need to compess automaticly...any ideas?

Do you mean that you need to use a compression utility against it without user intervention? If so, you can launch a file compression tool, either with a command line utility using the DOS RUN command or something like the API_APPRUN class (for example, using PKZIP), or programatically using an ActiveX tool like DynaZip.

If you're looking for something that will maintain the file with automated compression on the disk drive, your best bet is to maintain the file on an NTFS volume and enable compression under NT - that will automatically compress and decompress the file on the hard drive as the file is accessed, similar to what things like DriveSpace do for Win9x/DOS, but in a much more reliable fashion. DriveSpace3 under Win98 is a good second choice, but as I recall, you're limited to working with FAT16 (2GB disk volume sizes). I'd avoid earlier Win9x compression tools, and stay as far away from NetWare's file compression as you can - there are tremendous problems associated with database apps accesing files under NetWare drive compression documented in both Novell's and Microsoft's KBases.