Getting Your "Favorite" <Microsoft Product> Bug Fixed
A very interesting article describing how Microsoft personnel decides which bugs get fixed first. Getting Your "Favorite" SQL Server Bug Fixed. This does apply to other products within Microsoft.
Allen Brown, of course, has done a fine job of documenting a number of these "quirks", shall we say, in Access 2003 and older and has had some of those fixed in Access 2007. He is also tracking bugs in Access 2007.
If you want a bug fixed write something up along the lines suggested and post it to the public Microsoft newsgroups. This will bring up some discussion for possible work arounds and, if we fellow MVPs feel it is worth while, we'll send it off to the Microsoft Access team. Be meticulous on your repro steps.
For example there was some recent discussion in the public newsgroups on why The ID field is increment by one every time that you add a field to a new table in Datasheet view in Access 2007 was not fixed in Access 2007 SP1. Part of this may very well have been that it was too late in the Service Pack cycle to get it fixed. However Microsoft personnel may also have decided that this particular bug doesn't impact many people and put it at a lower priority than other bugs. So it might get fixed in SP2.