Using SQL Server 2005 Express with VB6
Here is a nice post that describes how to use SQL Server 2005 Express with VB6 - you don't need to be coding in .NET to take advantage of the latest version of SQL Server.
I'll currently working on some stuff for/with SQL Server 2005 Express and VS 2005. You'll start hearing about over the next few months - stay tuned.