Showing results for 
Search instead for 
Do you mean 

Custom Table found on rebuild

Loyal Listener
Posts: 42
Country: United_Kingdom

Custom Table found on rebuild

Still trying to rebuild our 300k record database following breaking 4gb limit.


It would appear that sometime in the past there have been some Custom FIelds created, either by an Act Consultant pre Act 6 or by conversion to Act 2007/8/10.


Some of these fields are related to a Custom Table:

    ACT! Table: Custom Table 0   Physical Table: CUST_CustomTable0_033916


Whereas others aren't eg


ContactCUST_CustomTable0_033916Custom Table 0CUST_PreviousRole2_033929671



 The fields from this Custom Table appear in the Fields List for me to create in a blank database except these two:


ContactCUST_CustomTable0_033916Custom Table 0CUST_CustomTable0_033916ID

ContactCUST_CustomTable0_033916Custom Table 0CONTACTID


These look like link fields between tables, do I need to go back to an ACT 6 backup and see what the table is or are they more likely a function of the conversion process from ACT 6 to 2007?


Paul M Tate