08-08-2017 04:56 AM
It does appear that it is correctly sitting on the PC you are using. It maybe required to detach and reattach the database to get this correctly working again.
Again I would like to ensure you have a recent backup taken before proceeding with this step. the article guides on using Actdiag to detach and provides a separate article on reattaching.
As an alternative it maybe worth to restoring a copy of the database to work on and test further.
08-09-2017 12:22 AM
That still didn't work - same non-local database error.
Also, in the Country defined fields the default Country is once again greyed out.
08-09-2017 04:36 AM
At this point I would restore a backup of the database using 'File > Restore > Database > Restore As'
Once you have the backup can you test to see if the issue is still present and if it is attempt to create an empty copy of the database.
If this allows an empty copy to be created we can then test the earlier theory.
08-09-2017 04:59 AM
Thanks. Did both those actions.
New empty database still has US as default phone/mobile and the the Country defined fields the default Country is greyed out.
Haven't tried reschema - should I? Or something else?
08-09-2017 05:39 AM
If you can I would suggest you restore a previous backup using the restore as option giving it a new name.
Once restored open your corrupted database, lookup all items using the edit date in contacts since the backup and then export to the restored database.
This should get you back to a stable and up-to-date database.
08-09-2017 05:50 AM
08-09-2017 06:52 AM - edited 08-09-2017 06:52 AM
"the Country defined fields the default Country is greyed out."
Could you clarify what is meant here? as i am unsure where to look.
The country code should be pulled from the creating Users country. Can I confirm if you go to 'Lookup > My Record' that you contact has the desired country chosen.
08-09-2017 08:55 AM
Sorry if it's confusing.
Greyed out default country field in Tools > Define fields> Country > Default Value (optional).
Issues with database are:
Have tried all your suggestions:
New 'test empty copy database' still has issue 1-2 but issue 3 has gone.
This all started following changing some fields from Character to Initial Caps (as described in initial post).
So not sure what to do?
08-10-2017 09:18 AM
I believe the Country's default value being greyed out is working as designed as some System fields doing prevent you from entering default values.
On your own contact as well as having UK selected as the country can i confirm your country code is set to UK?
Do you happen to recall the field that you had changed to Initial Caps? if this was a system field it potentially could of cause damage to the structure of the database.