Skip to main content

Practice Management: Upgrade issue database upgrade after 11.4

Your Access APS Practice Management database stays on version 11.3 after you upgrade to 11.4.

If your Access APS Practice Management database did not upgrade when you installed 11.4, you can complete the upgrade manually.

After you upgrade from 11.3 to 11.4, you may notice one or more of the following:

  • The database remains on version 11.3 while the application shows 11.4.

  • Access APS Practice Management does not function as expected after the upgrade.

  • Your IT administrator identifies missing connection records in the aaDBConfigList table.

  • The database upgrade prompt described in Part 4 of the installation notes did not appear during the upgrade process.

This happens because the database upgrade is a separate process. If it does not start automatically, you must run it manually. If the PMDatabaseUpgrade file does not run, or Windows security settings block it, the database stays on version 11.3 and the required schema connection records are not added.

⚠️ Important: You need administrator-level access to both the APS server and the database. If you do not have these permissions, contact your IT administrator or APS Support before you continue.

To upgrade the database manually, complete the following steps:

  1. Open the Adv2000 installation folder on the APS server. This is typically C:\Adv2000\ or your organisation's designated install path.

  2. Locate the file named PMDatabaseUpgrade.

  3. Right-click the file, then click Properties.

  4. If an Unblock checkbox or button appears at the bottom of the Properties window, select or click it, then click OK. This removes the Windows security block on the file.

  5. Run PMDatabaseUpgrade by double-clicking it. Ensure you are logged in as a user with database administrator permissions. The upgrade will not proceed without them.

  6. Follow the on-screen prompts to complete the database upgrade.

  7. Once the upgrade is complete, restart Access APS Practice Management, then verify the application and database versions match.

If the upgrade file does not run, or the version mismatch continues after you complete these steps, contact APS Support for further assistance.

Did this answer your question?