I am relatively new to VB/SQL, and being an (old) FoxPro guy I am used to doing this somewhat differently, but my question is this:

I can drag/drop ADOC controls on a VB Form, attach to my MSDE SQL Server, and use the Recordset methods and properties without much trouble. However, I want to raise my expertise up a notch; could someone provide me with an example of how to access the SQL engine entirely in code?

I am using VB 6.0 and MSDE on a single machine.

Many thanks!

-Irv.