>>>>A data session has 32,767 work areas, but there's a limit of 2,551 tables open at a time application-wide.
>>>>
>>>>>Is there any restrictions on how many tables you can open in a data session?
>>>>>Thanks
>>>>>James
>>>
>>>Josh, actually it is 255 tables - the number 2551 in VFP 5.0 help it is just 255 with reference number one (which says that it is limited with memory and available file handles) In VFP 6 help it looks normally -
>>>
>>>" Maximum # of fields per record(¹) - 255 "
>>>
>>>Nick
>>
>>Sorry, copied the wrong line :)
>>
>>"Maximum # of tables open at one time(²) 255 "
>
>I just wonder: if you have let say 6 forms with private DS having each ~30 tables then assuming that index file takes a handle we are pretty close to limit. Is it correct?
Looks like that ( we should add the whole bunch of file handles used by the files opened by Windows). Cannot check right now - don't have that many tables. But I didn't check what happens in private datasessions if at least part of those tables are the same. At least within the same datasession you can open the same table 1000 times (USE AGAIN) and it is OK (except it is slow :). This way they all should use the same file handle.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison