The Access 2007 run time is available if you need it. It's in the Developer Extensions, which also includes a Package wizard which is supposed to make .msi installers for your Access project. The extensions also have a source code component that allows you to check in Access objects into Source Safe or something. There was a similar control in Access 2003 that worked so-so.
Access Developer Extensions and Runtime

One of the huge deficiencies in the Winforms area was the ability to design something that works like the continuous forms in Access. FINALLY they have addressed this! In the new VB.Net powerpack, there's a control that gives you a continuous forms capability for your Windows forms apps.
PowerPack

There's a video link in the upper right corner of the page that introduces it. Here is a short video on how to use it: Video

I am finally doing an Access project, from scratch in Access 2007. Since there is so much new, I thought I would make an ongoing article here to document new features, quirks, bugs, and stupid things as I find out about them. My goal is to update the article as I go, so you might want to re-read it once in awhile.

If you haven't already seen this, here is a link to Scott Guthrie's blog entry announcing Silverlight 2.0. What, 2.0 already? Basically they renamed the 1.1 version to 2.0 since there is so much new functionality. The part that excites me the most is they are including user input controls (textbox, checkbox etc.)! This was a huge missing piece in 1.0, and their inclusion means we can develop real interactive user interfaces in a Silverlight environment. More to come on this. Oh and, the beta release will be a 'go live' release which means you can build and deploy production apps with it.

Microsoft is officially asking for feedback on Access! This posting was recently put up on the Access Team Blog at Microsoft:

A great opportunity has just come up for you folks to get some feedback into the Access dev process. Dany Hoter, one of our product planners who is studying the Access business, is interested in talking to Access developers to understand better the kind of solutions they create. He would also love to discuss your thoughts on the competitive landscape of data tracking and application building, especially any insights you may have on the world of web applications and services. If you are interested in participating, please feel free to send mail: Dany.Hoter@microsoft.com

Now that Silverlight is released to production, you can do some really serious applications :) Well I decided to do a decidedly non-serious app that calculates and displays a fractal image. All in good fun, but I did learn a few things about Silverlight along the way. See the article and demo here.

I can't resist getting on the Silverlight bandwagon. It's still a new, unproven technology, but its fun and relatively easy to work with. And even non graphics developers can turn out some snazzy eye-candy. But in my first article, I'm not focusing on eye-candy, but rather practical matters of displaying dynamic data from a SQL Server database in Silverlight 1.0RC. Check it Out!

Why write a bunch of procedural code, or worse, XSLT to create an RSS feed for your web site? Use the power of SQL Server 2005 to create RSS XML directly from your article data. New article here.

There are three new Access articles to start off that section, a couple on linking SQL Server tables in Access, and on code error handling. Check them out!