Record Size to big for table error??

[JasonDBurke]

Hi,
I am writing to an SQL Server 2000 database and presently writing about 1500 records with 40 fields...will be more in the future. At about 37 fields the BDE is throwing a "Record Size to big for table" error. I looked it up and it is error code 9477, Resource or Limit Error". What exactly does this mean? Does this mean that the memory allocated by BDE, i think about 64K, is not enough for the transfer of records?? How can i deal with this problem? The main database needs to hold about 80 fields and up to 100,000 records.Thanx
Jason

 

[TealWren]

You could try using ADO instead! That is probably a better fit if you are only using SQL server.

TealWren