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.