I am trying to build a database to store vedanta knowledge in Access Database using Unicode Text in tables. The text is in Hindi/Sanskrit language and is saved well in the data tables. But when I try to build forms for it Access informs that -
"Microsoft Office Access cannot save the form as it displays characters from a language that cannot be saved in your current system locale. Switch your system locale to the language in the form and then try again."
I tried changing system locale to this language i.e. Hindi but the list of languages in it does not contain Hindi or Devnagri. I seek help from expert forum members to suggest a way. I herewith attach the database to have a look. Please help.
Strangely I find that Access (2007) saved a form created by command Create -> Form for table named "Translations_and_Commentaries" which contains similar unicode text in Hindi but would not save forms created in similar manner for other tables named "Shlokas" and "Epic_Master".
I urge the knowledgeable members to provide help on the issue. Kindly.