Creating Queries in VB (Access 2003 MDB)

[Guest]

Hi,

I'm having problems creating a query in VB, I'm not too sure how to go about
it? I am using querydef at the moment but all this seems to do is to
physically create a saved query in my database, I need to be able to get the
records and use the results programmatically.

Also, what's the difference between ADO, ADODB, DAO etc? All these acronyms
are messing with my head!

Cheers,

Toby

 

[Ken Snell [MVP]]

Check out OpenRecordset in Help ... that allows you to open a query or table
in code and use its data.

ADO is one library for gaining access to data, as is DAO. DAO was developed
for use with Jet engine; ADO is a more generic method for all types of data
engines. ADODB is one part of ADO, and you typically use ADODB for
recordsets, etc.