How could I fix the overflow table problem?

[ita]

Hello,

I was adding fields in the opportunity table and at some point I can't find it in the TBL_OPPORTUNITY table in sql server anymore, it turned out that these fields are in an overflow table. How could I fix this so that everything is recorded in the TBL_OPPORTUNITY table?

Thank you in advance.

emergency !!!

[Melville-Schellmann]

You can't fix that. Once a custom table (="Overflow table") was created in the database, it will stay there. The reason for that new table is very simple: the "basic" table is "full" because you added some fields to your database.

[ita]

But it looks like the base table can go up to 1000 fields while I m only at 37 fields. So there is space available. That is my concern.

[Melville-Schellmann]

Due to the various field types ACT! can use, a table becomes full far before this theoretical limit is reached. Rest assured that everything is in good order!

[ita]

Ah okay I see! Thank you very much for your answers

[Eagan_1]

I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work MyAARPMedicare.