Here's a little more comprehensive example I made

http://www.1337geek.com/code/vb6/database/ADODB/