You may want to consider the Advantage Database Server system at www.advantagedatabase.com

Data extracts can be as much as 100x faster than SQL and it has native data encryption and protection for a fraction of the cost.

Free trial version download.


>I am building a project that will involve a large database
>(10-20 million records). The basic functionality will be 3 tier,
>a back end database, middleware business logic - batch transaction
>oriented, and a front end desktop application with a small database.
>
>I am considering using SQL Server for the back end, and VFP for the
>middle and front end. Is this a good idea?
>
>I would appreciate any tips, tricks and traps, or alternate
>suggestions that anybody has.
>
>Thanks,
>Burt