03-25-2010 12:30 PM
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
|Contact||CUST_CustomTable0_033916||Custom Table 0||CUST_PreviousRole2_033929671|
The fields from this Custom Table appear in the Fields List for me to create in a blank database except these two:
|Contact||CUST_CustomTable0_033916||Custom Table 0||CUST_CustomTable0_033916ID|
|Contact||CUST_CustomTable0_033916||Custom Table 0||CONTACTID|
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?