My Day Job

You may have gleaned from my first blog post that my day job is at Microsoft. Well, today two of my babies finally shipped. I am the program manager for the Access Developer Extensions and the Access Runtime. This project surprised us with several unexpected challenges, but we are happy to finally be able to point people at the official downloads.

In order to build the CheckOutMyCards.com website, we use many different technologies, but the heart of the site is driven by a Microsoft Access application on top of a couple SQL Server 2005 databases. Andy (or web developer) and I use the Visual Studio Team System to manage all of our source code for the web site, SQL Servers, the Access application, and some managed code DLLs used by the Access application.

For the last 4 months, we have been “dogfooding” the Access Developer Extensions’ source code control integration with Access 2007. This allows us to check out, undo check out, and check out individual queries, forms, reports, macros, or modules. My favorite feature is the “Show Differences” right-click command. A lot of times you forget the changes you made to a file, and it is extremely handy to be able to see exactly what changed in a module before checking it in.
Tim’s Sports Card App

If you clicked on the screenshot, you may have noticed that we are actually using Team Foundation for our source code control provider. Access actually allows you to use any source code control provider that implements the MSSCCI interface. Typically, small development shops use Microsoft Visual SourceSafe, but if your enterprise has standardized on the Visual Studio Team System, you can install the Team Foundation Server MSSCCI Provider so that your Access databases can be under source code control.

If you want to stay tuned to what the Microsoft Access team is up to, you should subscribe to the following blogs.
The Access Team blog
Clint Covington’s blog

3 thoughts on “My Day Job

  1. Congratulations on shipping!

    On a Team Foundation Server note, does the SourceSafe diff tool support any sort of code merge?

    PS – That’s a leading question because I have a separate solution that I used on our code line this afternoon. (This was in part ghost-written by Toby who’s sitting my velcro chair).

    Congratulations again!

    -Dave Persing

  2. Dave, good question. Yes, Team Foundation does support code merge. However, Access forms, reports, and queries are not merge friendly. Usually you have to manually fix merge conflicts, and that is why Access defaults to only letting multiple people check out VBA modules. VBA merges nicely.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s