How to fix "Schema needs to be updated" error
The database in Desktop-Reminder 2 and DR 3 is the same MS Access file.
However in DR 3 it contains additional columns.
After upgrade from DR 2 to DR 3, the database is migrated automatically.
In a rare case it does not happen, and the following error message will be shown:
"Schema needs to be updated. Contact your system administrator. Sql text: Column 'RemindTime' not found in table 'Task'."
The reason is not completely known.
Most probably it could be opening DR 3 whereas DR 2 is still running, and blocking the DB from the migration.
Solution 1
If it does not fix the error, add the "RemindTime" column manually.
Solution 2
Open the tasks.dr3.mdb in MS Access.
If you have no MS Access, you can use MDB Viewer
http://www.alexnolan.net/software/mdb_viewer_plus.htm
Open the table "Tasks"
Add the column "RemindTime" of Type DateTime
Save the DB and retry opening it in DR 3.
Back to FAQ
However in DR 3 it contains additional columns.
After upgrade from DR 2 to DR 3, the database is migrated automatically.
In a rare case it does not happen, and the following error message will be shown:
"Schema needs to be updated. Contact your system administrator. Sql text: Column 'RemindTime' not found in table 'Task'."
The reason is not completely known.
Most probably it could be opening DR 3 whereas DR 2 is still running, and blocking the DB from the migration.
Solution 1
- Close all instances of Desktop-Reminder 2 and 3 (File->Exit).
- Rename the database file from tasks.dr2 to tasks.dr3.mdb, if it not already happened.
- Start DR3 and open the DB file (Data->Open)
If it does not fix the error, add the "RemindTime" column manually.
Solution 2
Open the tasks.dr3.mdb in MS Access.
If you have no MS Access, you can use MDB Viewer
http://www.alexnolan.net/software/mdb_viewer_plus.htm
Open the table "Tasks"
Add the column "RemindTime" of Type DateTime
Save the DB and retry opening it in DR 3.
Back to FAQ