Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

 

ContactTBL_CONTACTContactCUST_PreviousRole_033914343
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?

TIA

Paul M Tate