I had to match a font from a letterhead today and I came across a couple of great tools for the task.
First I found FontMatcher, a VB6 program that takes a BMP image and matches it to your TTF files. The catch is that you have to have the font already for it to find it. I didn’t so it didn’t match my font.
I finally found a great tool that searches their own online font database: What the Font. It even allows you to purchase the font after it finds it for you 
. Saved me a lot of time though - it’s worth it.
It’s fairly easy to take an MDB database and convert it to SQL Server, but how about taking an SQL Server database and downloading it into an MDB file (Microsoft Access)?
This article has some code to do just that: http://www.codeproject.com/useritems/SQL_to_Access_Data_Export.asp
Just searched the net trying to figure out how to do an update using an inner join. I figured it was possible, and I was right. Here’s how to do it:
UPDATE Table1
SET Table1.Title = Table2.Title
FROM Table1, Table2
where Table1.ID = Table2.ID
If you are using aliases - for instance if you are updating a table you are joining to itself, use this code:
UPDATE Table1Alias
SET Table1Alias.Title = Table2Alias.Title
FROM Table1 as Table1Alias, Table2 as Table2Alias
where Table1Alias.ID = Table2Alias.ID