Access Database Problems

2014/07/19 14:28

In the process of compacting the database, if there is any error (such as server's power failure or abnormally shut down), then it will rename the ".mdb" data file, which will not let you find the email account data in AAMail system. The problems can be mainly divided into the following two cases.

Compact Error

When you compact Access database with AAMail system tool, the server shut down abnormally or had power failure, and you found there are problems with receiving mails, or the mails and attachments are missed.


Upgrade Error

After upgrade from Access to SQL, the server shut down abnormally or had power failure, and you found that the old mails or attachments are missed.

Solutions

1) Modify the renamed data file (such as "yaozhi.mdf_") to "yaozhi.mdf" by deleting the "_".

2) Close AAMail's all processes.

3) Open the "mailserver.ini" file in the "C:\AAMail\data" folder.

4) In the "mailserver.ini" Notepad, modify the "DatabaseSetup=1" to "DatabaseSetup=0"

5) Run AAMail again.

6) Upgrade Access database again.




Related: