Microsoft Links
MSDN: Access 2007 Resource Center
Access 2007 Download: Access Runtime
Access 2007 Download: Access Developer Extensions
Office Online: Access templates
Access Developer Links
Utter Access - Discussion forums for Access and other Microsoft tools.
Blue Claw Database Design - Access consulting and custom solutions. Nice (and free) tutorials on the website too.
Access Monster - Access index and search site.
The Access Web - Access FAQ site. Not as active as it used to be but still has lots of info.
Stephen Lebans - Access MVP's website (last I checked it appeared the site had not been updated lately).
See also
Microsoft Development