Table of Contents

Error Message

“Table is Full” …

Explanation of Error

The BDE limits the size of the data transferred onto the HD in the BDEAdmin. As databases grows and as HD size have exceeded 4 GB, there is an increase need for larger block size transfers

Resolution 1

  1. Run the dbrebuild

Resolution 2

  1. Navigate to the BDEAdmin.exe (located in the “Program Files\Cyrious\Common\BDE\” folder)
  2. Go to Configuration
  3. Drill down to Native
  4. Drill down to Paradox
  5. Increase the block size to 16384, 8192, or 4096. Only increase the block size in multiples of 4096.
  6. Set the level to 7
  7. dbrebuild the database

Resolution 3 (this requires assistance from Cyrious Tech Support)

  1. After you have tried the first two configurations, you should proceed with these steps. It is important to note that before proceeding with recreating the tables that you confirm the BDE block size has been increased. When the tables are created via the queries below the new tables will only have an increased block size if the bde block size has been set properly.
  2. The queries below are for SMS 8.91 tables but you can modify them for prior versions of SMS by deleting the additional fields that are not needed in earlier versions.
  3. Rename the existing tables to a new name.
  4. Run the queries below to create new tables.
    1. sql_to_create_adjustment_database_for_sms_8.91.txt
    2. sql_-_create_estimate_database_for_sms_8.91.sql
    3. sql_-_create_estimate_details_database_for_sms_8.91.sql
    4. sql_-_create_order_database_for_sms_8.91.sql
    5. sql_-_create_order_details_database_for_sms_8.91.sql
    6. sql_to_create_gl_database_table_for_sms_8.91.txt
    7. sql_to_create_payment_database_for_sms_8.91.txt
  5. Run the queries below to import the original data into the new blank tables.
//FOR Example
INSERT INTO "Adjustment Database"
SELECT * FROM "Old_Adjustment"
;
INSERT INTO "Estimate Database"
SELECT * FROM "Old_Estimate"
;
INSERT INTO "Estimate Details Database"
SELECT * FROM "Old_EstimateDetails"
;
INSERT INTO "Order Database"
SELECT * FROM "Old_Order"
;
INSERT INTO "Order Details Database"
SELECT * FROM "Old_OrderDetails"
;
INSERT INTO "GL Database"
SELECT * FROM "Old_GL"
;
INSERT INTO "Payments Database"
SELECT * FROM "Old_Payments"
;