🚀 go-pugleaf

That's the downside to using a desktop database like Paradox & Access,
sometimes you max out the size of the table then you're out of luck. There
are physical limitations to the size of a Paradox table that takes in
consideration the number of bytes in each record and of course, the number
of records in the table. I don't recall using Paradox tables that exceeded
somewhere around 150 Mgs..  You can probably consult the Borland
documentation for the precise specifications. These desktop databases are
not as scalable as say SQL Server or Oracle... There are some work arounds,
for example I recall a previous article in the C++Builder Developer's
Journal that discussed how you can expand the size of each block in the
table and thus increase its capacity, secondly you can always break up the
table or even reduce the number of fields in a record....  The ultimate
solution of course is to port your application to a more scalable database
architecture....

Antonius Aryanto wrote in message <3ac56a66_2@dnews>...
>Help me please.
>I have an error message when i try to scroll down my data in database
>explorer. it says "Lock Table is full". it just happens in some tables (not
>all tables), and that table contain a lot of data. i think because that
data
>in the table is too many. i don't really know. so please help me.
>why it happens. how to solve this problem.
>
>thanx anyway.
>
>

Delete Paradox Lock Files, I think its maximum size is 64 MB, then rerun
your application,

PARADOX.LCK
PDOXUSRS.LCK

F.Y.



"Antonius Aryanto" <aryanto_a@hotmail.com> wrote in message
news:3ac56a66_2@dnews...
> Help me please.
> I have an error message when i try to scroll down my data in database
> explorer. it says "Lock Table is full". it just happens in some tables
(not
> all tables), and that table contain a lot of data. i think because that
data
> in the table is too many. i don't really know. so please help me.
> why it happens. how to solve this problem.
>
> thanx anyway.
>
>