I'm just wondering.  I see a lot of people using TableDef and QueryDef.  I
almost always use OpenRecordset.  What are the advantages/disadvantages of
using them?

Dan,

- tabledef - the definition of the structure of a table. You can
iterate the fields and properties and so forth. You don't use this to
read and write data, but to get information ABOUT the table

- QueryDef - this is basically just a saved .SQL statement. Can be
used to create recordsets

- Recordset - the actual set of records created by opening a recordset
on a 'table', or a 'query' or a sql statement.

-- Jim Ferguson, FMS
   http://www.fmsinc.com

They are all different objects and methods.  A TableDef is an actual table
in a Database, and a QueryDef is an actual Query in a database.  The
OpenRecordset is a method to open the Table or Query.  Now, back in the
Access 2.0 and Jet 2.0 days, you had the OpenTable method and the
OpenQuerydef methods, which are both obsolete now and have been replaced by
the  OpenRecordset Method.

By the way.... the OpenRecordSet Method does have options to open a Table,
Dynaset or Snapshot.

Jason Cragun