Board index » delphi » BDE 4.51 Open table Limits ???

BDE 4.51 Open table Limits ???

Hi All Delphians !!

I have a project under Delphi 3.02 & BDE 4.51 with Paradox 7 Tables under
W95, and when I trye to execute it in the moment it opens the main window
display the message :

BDE error : Too many tables open

But, I have 47 tables in a DataModule connected to TDataBase, and in the
INternal Limits of teh BDe TI12751 says that :

2048 Open Databases per sesion (4.0, 32bit)      (General BDE limits)

254 Tables open per system (BDE 4.01)     (Paradox Limits)
1024 Open physicals files (DB, PX, MB, ...   BDE 4.01)

I have only 184 physical files (DB, PX, MB, ...) and 47 Tables on the
Project.

What is Wrong ?
Some Ideas ?

Thank you to all

--
Juan Coru?a Rodriguez
Tecnosoft S.C.P.
E-Mail : tecno...@futurnet.es

 

Re:BDE 4.51 Open table Limits ???


Quote
Juan Coru?a wrote:

> Hi All Delphians !!

> I have a project under Delphi 3.02 & BDE 4.51 with Paradox 7 Tables under
> W95, and when I trye to execute it in the moment it opens the main window
> display the message :

> BDE error : Too many tables open

> But, I have 47 tables in a DataModule connected to TDataBase, and in the
> INternal Limits of teh BDe TI12751 says that :

> 2048 Open Databases per sesion (4.0, 32bit)      (General BDE limits)

> 254 Tables open per system (BDE 4.01)     (Paradox Limits)
> 1024 Open physicals files (DB, PX, MB, ...   BDE 4.01)

> I have only 184 physical files (DB, PX, MB, ...) and 47 Tables on the
> Project.

> What is Wrong ?
> Some Ideas ?

> Thank you to all

> --
> Juan Coru?a Rodriguez
> Tecnosoft S.C.P.
> E-Mail : tecno...@futurnet.es

Hello,
  Try increasing MAXFILEHANDLES in teh BDE Admin to 255.  You are
starting to push the limits of the BDE and your machine.  You might want
to consider opening your primary tables at startup and then opening
other tables as needed.

  Scott
--
BDE Support:
 http://www.borland.com/devsupport/bde
Delphi Support:
 http://www.borland.com/devsupport/delphi
Common Delphi and BDE Questions and Answers:
 http://www.borland.com/devsupport/delphi/qanda/delphi3qa.html

Other Threads