Board index » delphi » Limmited Recordsize with BDE 5.01 and MSACCESS?

Limmited Recordsize with BDE 5.01 and MSACCESS?

hi there,

i am trying to create an access-table (97) with the bde using
an sql-query - but there seems to be a record size
limitation. when i try to create a table with a recordsize
bigger than 2000 bytes, i get an error back from bde, that record
is too big.

i tried to create it with the paradox-driver and it works
perferctly.

any idea how to solve that problem? is there any solution?
do i habe to use a TTable object to create the table? or
will i get the same problem with TTable?

does anyone have experience with this?

bye od

 

Re:Limmited Recordsize with BDE 5.01 and MSACCESS?


If M$ uses the same allocation methods for Access that they use in SQL 6.5
then you are limited to the allocated page size.  In SQL versions up to 6.5
this ment a max record size of about 1960 bytes.
Quote
O.Dawid <O.Da...@gmx.de> wrote in message news:3779B966.BF7F5F30@gmx.de...
> hi there,

> i am trying to create an access-table (97) with the bde using
> an sql-query - but there seems to be a record size
> limitation. when i try to create a table with a recordsize
> bigger than 2000 bytes, i get an error back from bde, that record
> is too big.

> i tried to create it with the paradox-driver and it works
> perferctly.

> any idea how to solve that problem? is there any solution?
> do i habe to use a TTable object to create the table? or
> will i get the same problem with TTable?

> does anyone have experience with this?

> bye od

Other Threads