This is VB6 and Access 2000. The following code snippet very nicely calls a stored query in an Access database: conn.Open "dbtest" Dim rsTemp As ADODB.Recordset Set rsTemp = conn.Execute("Query1") If ...
The Recordset object is an essential component in Access development, but it often trips up even experienced developers. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and ...