>Any and all thoughts, suggestions and help would be greatly appreciated.
>
>Have VFP 6 (enterprise edition) (service pack 4 installed) running on a NT Server 4.0, Dell 6400 box with Raid 5, 4 processors, 168 GB disk space and 2 GB memory.
>
>Reading a table (table a), this table has 4.8 million records, (size is 1.3 GB). From this table I am populating 12 relational tables. The largest of these is an address table which has about 3.8 million records (size is approx 454MB and a 500MB cdx) and a case table, same as address, ALL under the 2 GB limit.
>
>Doing a simple Do while on “table a”, storing info in a cursor, (created with a Create Cursor…) then doing indexseeks on the relational tables and either Inserting info or replacing info as needed.
>
>Should work OK, right…wrong. VFP keeps giving me an error “Not enough memory for file map”. (There is a 2 GB permanent swap file). This would start when record number 1.2 million was reached, now it’s happening at record number 465000.
>
>Buffering has been switched off in the project manager and all files are opened exclusive.

This is a SWAG, but VFP might not play well with huge amounts of available RAM. You could experiment with SYS(3050) and try limiting its use to some reasonable value, like 128MB or 256MB.