Updating recordset dating in kent
This forces Access to wait while all records load, so the Record Count reflects the entire recordset.
Eschewing the complex data types is a perfectly valid choice if you only deal with databases you created, but if you support end users or write generic utilities to work with any Access tables, you must learn to handle them.
So if you later split your database so the tables are attached, the code fails when you use a method that no longer applies. Dynaset guarantees your code will work for all queries and tables, local and attached.
Example: Using any of the Move methods (Move First, Move Last, Move Next, or Move Previous) causes an error if the recordset has no records. Either of these approaches works: For recordsets based on queries, SQL statements, and attached tables, the Record Count property returns the number of records accessed so far.
Specifically test for and handle the complex data types if your code must work with databases in Access 2007 or later.
Particularly, if you: The Find-as-you-type utility contains a practical example of testing for and excluding the complex data types in the function Find As UType Load(), while ensuring the code still works in earlier versions of Access.
Example: It is poor programming to open anything without explicitly closing it. Short of pressing Ctrl Alt Del, you may find that Access will not quit if recordsets or other objects are not closed and dereferenced.