Unanswered: MS Access frontend - displays '#Deleted'
I'm using Access XP as a frontend to a MySQL database. I have the latest updates to the Microsoft Jet DB engine installed and I'm running MySQL 4.0.13. Is there a way to avoid Access displaying "#Deleted" when a new record is being added to a table? The data is saved properly and appears correctly when the table is closed and reopened. This seems to occur when the Primary Key is set as auto_increment. I'd appreciate any help you can offer.
U can actually compact the Access database.
For wat i know, when u delete the data inside the database, the Access actually have a cache inside. U can notice that the file size of Access DB will keep on increasing.
So, u can compact the database so that it will empty the cache.