I have become very comfortable programming with Access recordsets in VB6. I'm now using VB 2005 Express Edition and want to learn to use the "new" database, but I am very confused. I've done searches on the internet but just get more confused.

I think VB6 used DAO and VB 2005 uses ADO? And what the heck is OLE DB and ODBC? I am assuming I want to start using the SQL Express database instead of Access, but do I need to use the SQLConnection to connect to it? I've read Beacon's ADO Tutorial, but it uses ADODB.Connection to connect to an Access database. Isn't that becoming outdated?

I deal with pretty simple databases. Can somebody provide me with some basic info so I know what direction I need to head to learn more? I'm willing to scrap my old knowledge and learn what's currently most popular. I'm just not sure what that is.

Thanks.

Greg