This sounds like the problem that occurs when you requery a view 465000 times without closing it. In VFP 5, the limit was 64000.

Whenever a requery was done, a new entry into an internal file map table was added. These entries were not purged until the view was closed (or the datasession was closed). When VFP 6 came out, the problem was not corrected but the limit was increased (I don't have any information as to how the limit was increased) to 465000.

While this doesn't sound exactly like your environment, it may be a place to start. Without knowing your exact situation, it is hard to offer alternatives but they do exist.

Good luck!

>guys were smart... legends in your own mind... Like Drew speedy
>
>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.