02-21-2021 04:54 AM
02-22-2021 03:05 AM - edited 02-24-2021 06:33 AM
This problem is a throwback to the original ACT design where ACT has a table with all the contact fields in it with a maxim size count for the whole table. If you create new fields ACT puts these in an overflow table once the table count has been reached so you never see the error that you are seeing
If you increase the field lengths in the original table there can become a time where you exceed the total size count for the table
You can reduce the size of some of the original ACT fields like the Home address fields if they are never used
Create a new field, copy all the information from the OLD field to the new one and update the layout.
NB Can only be done on the master database and always make a backup first.
02-22-2021 05:01 AM
Thanks for the reply.
I have attempted to make changes on the master I get the error message Unable to communicate with server. You may need to log on to Act.......
Think I need to raise a ticket!
This database, created in 2008 has had many changes over the years. The main user wants so many other changes. I think a re-think is in order.
Thanks again for the help.