Running a repair for MYOB Accountants Office

This support note applies to:

AO Tax (NZ)
AO Practice Manager (NZ)
AO Practice Manager (AU)
AO Workpapers (AU)
AO Statutory Reporter (AU)
AO Tax (AU)

Article ID: 35010

After restoring an MYOB Accountants Office (AO) database, or if you encounter software problems, you may be asked to run a Repair of MYOB AO. This updates any incorrect or invalid paths and ensures all corrupt or missing files are replaced.

To repair MYOB AO

Launch the same version of the MYOB AO installer you have installed. The Welcome screen appears.
Select the first option, 'An existing MYOB AO user?' and click Next. The Before you install window appears.
Read the Upgrade Guide, if required. Otherwise, click Next. The Install MYOB AO appears.
Click the link to install MYOB AO.
The MYOB AO Installation Wizard opens and detects that MYOB AO is currently installed, and so presents different options:
● Convert an MYOB AO Classic database;
● Repair;
● Uninstall.
Select Repair, and click Next. The System Check window opens and the installer does a system check to ensure that your system meets the necessary requirements, and if OK, takes you to the next step, Ready to Repair.
Click Repair. The installer runs through checking and reinstalling all required software and components. This may take between 20 minutes to an 1 hour.
Click Finish. The installation is complete.

MYOB Internal Notes:

You can use the below procedure to get into PM and Tax.

Note: Some features such as Tax Letters may not work until you run a Repair correctly. This procedure is best used for testing only.

Run the create user script attached through SQL Management Studio on the PM database i.e AODB1.
This will allow you to access PM. If you need to access Tax, continue below.
Still in SQL Management Studio, expand the tax database, i.e AOTAX1, and under Tables, delete DS6OP021 and DS6OP022.
Open System Release, right-click on the folder i.e Path S6:\\...AOTAX1 and select Properties, then tab through the folder properties and press OK.
This will allow you to access Tax but not open tax returns. If you need to open a Tax return, continue below.
Back in SQL Management Studio, under the AOTAX1 tables, right click on DS6CD104 and choose Edit Top 200 Rows.
In the top row with the RowID of 3, change the computer name under the Default Address, Quick add options, Ledger Address 3 and ABN columns.
This allows you to access tax returns. As mentioned above, after you have finished testing, it is advisable to run a Repair to get all functionality back.