>>>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?