I developed a small program one year ago. The purpose of this program (VBA) is to extract the information from Email in Outlook and store it in the MS-Access database. The program works smoothly previously until recently, when new mail arriving at the Outlook, the program was not able to extract the data and store it in database, after some investigation, i found out the that current database hold 6377 records or equivalent to 100MB of size. No matter how i try, the program just couldn't insert the new information into the DB, then i tried to backup my current database, and replace the Database with a fresh copy of database with empty data inside. Guess wat, the program can work again!

Can any expert out there tell me what is going on !!!??? Thanks alot for help.