Unable to open eM Client corrupt database

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 14: ‘unable to open database file’.
at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteCommand.GetStatements(Stopwatch timer)+MoveNext()
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
eM client worked OK Friday evenig but Saturday morning failed to open with the message
database verification and repairing failed

This is the log file i think
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
at MailClient.Storage.Data.DataStore.GetConnectionInternal(String relativeName, Boolean privateConnection)
at MailClient.DbRepair.CorruptionChecker.CheckCorruption(RepairOptions repairOptions, CancellationToken token)
at MailClient.DbRepair.CheckingProcess.Check(CancellationToken token)
Data:
databaseFile: c95db2a2-608b-4baf-86f6-f3314dd0018a\mail_data.dat

This usually means that the database is heavily corrupted so there are few options.

Some users have found that restarting Windows, or restarting eM Client a few times resolves the issue, but otherwise:

  1. If you have a recent backup, you can delete the current eM Client database, then restore the backup and eM Client should start working again without any problems.

  2. If you don’t have a backup, but all your data is synced with servers, then you can delete the database and start over. After adding your accounts, eM Client will resync with the server.

By default, the database is the C:\Users\yourusername\AppData\Roaming\eM Client\ folder. You may have to enable hidden items in Windows Explorer to get there.

1 Like

Many thanks,
Restarting Windows and eM Client worked?? but I lost all emails sent and received between last Monday and today i can live with that though.