Here is some feedback I received yesterday from a customer. It is nice to see people appreciate the visual improvements.
Overall we are happy with Access 2000 and everything worked (or we had developed workarounds for certain behaviors). However, we looked to Access 2007 for the following features.
We have been with Access since 1.0 (56 documented bugs, 52 of which were resolved in 1.1). Since then we have settled into a very comfortable routine based on incremental changes and improvements with each version.
Access 2007 is not an incremental change; it is a major and significant change in the look and feel as well as the user interface. We found the rearrangement of the interface significantly different and this caused that unfamiliar and therefore unpleasant feeling of having to work within a new environment. That said, and bugs aside, I think this is the best Access ever.