I can't access any item templates
It is possible to delete item templates, and if they are all deleted, the options to create them also disappear. To correct this problem, do the following.
• | Go to Maintenance Menu > Raw Data Viewer > SQL. |
• | In the box labeled 'Query test', copy (Ctrl C) and paste (Ctrl V) the following text. |
INSERT INTO ItemTemplatesT ( TemplateID, TemplateName, ItemType, Method, DateOffset, ItemNumber ) SELECT 1 AS TemplateID, "Premed" AS TemplateName, "MBS" AS ItemType, "Item" AS Method, 0 AS DateOffset, 17610 AS ItemNumber FROM SetupT WHERE SetupT.SetupKey=1;
• | Click the <View data> button. |
• | You will get one or two prompts which you should click Yes to. |
• | Go back to the Main Menu and Quit AA. |
• | Restart AA and then your templates drop-down list should look like this. |
From there you'll be able to recreate your templates.