01-06-2020 08:36 AM
I have 2 entries for Country
when I started my Db several years ago I made Canada my default for Country.
I can not edit that to USA. The field does not allow me access. How can I fix that? Thanks
01-07-2020 12:31 AM
01-07-2020 11:10 PM
Backup your database. While restoring the backup choose 'United States' as the country.
Edit the country field
Set default value to 'United States'
01-08-2020 01:42 AM - edited 01-14-2020 06:15 AM
The Country field is a system field and therefore behaves differently to most fields in the database. For some reason that's beyond me once a default has been set in the Country field ACT locks this in and you cannot change it.
The only way of overcoming this is to create a new database with all the same fields but with USA as the default (or possibly no default!) with all the same users and then do a database to database import.
01-30-2020 02:43 PM
I tried again.
I made a "Copy" with only me as the sole contact. All the fields were there.
Then I tried ti "IMPORT" my 'PAD' file.
I got an ERROR message "The SGL Database instance is unavailable".
I've used Act for probably 20 Plus years. A love-hate relationship. It has always been prone to idiosyncrasies at levels the common user can't navigate. It should be mounted on the KISS system.
Don't know where to turn. Thanks for your ear.