<div>
I'm sorry I didn't explain my error correctly, we always get a memory error on a table (but it can be ANY table). &nbsp;I found in some, Borland technical information regarding internal limits of BDE, that says that Paradox has as limits of:<br />
127 Tables open per system<br />
512 Open Physical files<br />
We have over 100 tables between the two applications. &nbsp;Some of the tables are shared. &nbsp;Counting the physical files we have well over 500. &nbsp;Do you think we shoulld change to a real database such os Oracle?<br />

</div>


I'm sorry I didn't explain my error correctly, we always get a memory error on a table (but it can be ANY table).  I found in some, Borland technical information regarding internal limits of BDE, that says that Paradox has as limits of:
127 Tables open per system
512 Open Physical files
We have over 100 tables between the two applications.  Some of the tables are shared.  Counting the physical files we have well over 500.  Do you think we shoulld change to a real database such os Oracle?


<div>
<div class="content wysiwyg-content">
I am working on a project that is is sharing Paradox (v. 7) data between two applications. &nbsp;There is many tables with various physical files. &nbsp;We are running into memory problems when trying to run both applications at the same time. &nbsp;We always get a Memory error on a specific table. &nbsp;My guess is we are hitting one of the internal limits of Paradox, such as open tables per system or open physical files. &nbsp;Does anyone know of a utility that I can use to tell me how many tables/files are open while running an<br />
application. &nbsp;If there is not a utility, is there another way for me to obtain this info?<br />
<br />

</div>
</div>


I am working on a project that is is sharing Paradox (v. 7) data between two applications.  There is many tables with various physical files.  We are running into memory problems when trying to run both applications at the same time.  We always get a Memory error on a specific table.  My guess is we are hitting one of the internal limits of Paradox, such as open tables per system or open physical files.  Does anyone know of a utility that I can use to tell me how many tables/files are open while running an
application.  If there is not a utility, is there another way for me to obtain this info?



Paradox Limits

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.