I agree with Brice It, mostly. I too loved the Access 2003 interface and have not yet felt comfortable in the new UI. Even though I took/passed the certification for Access 2007 I still feel like a stranger when working in it, never knowing quite were to go to find things and feeling like I'm "programming with mittens on".
But I too want to commend all the hard-working developers at Microsoft on the Access team. It continues to be a great platform for delivering real business solutions. I would love to implement the new features of Access 10, but I too am concerned about how/where I'm going to set up Sharepoint on our network. We'll see where that goes.
Finally, I must disagree with Bruce's last thought, that Microsoft doesn't listen. It's just a question of who they are listening to. Remember that there are power users, end users who are not developers, who ask for functionality too. I once heard a Microsoft Access Team rep talk at our user group meeting here in Denver where he called Access a "landing pad for data". That's what it is for many users and that appears to be the audience targeted by the new version.
That's not to say I'm happy with the direction, only that I understand it. In my humble opinion, they have turned Access into "Excel on Steroids", which is great for power users, but not for Access application developers.
That having been said, one could criticize me for not biting the bullet and learning how to manipulate the new UI in code. I know there are developers who have, who can bend the ribbon to their will. I guess we old-guys-of-Access need resources that will help us become New UI Developers.
So to the Microsoft Access team I can only say, "Kudoos!" and "Thanks for all the fish."