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.
Also any tutorial sites or other info about the specifics of using MySQL with Access would be great.