I have a table with 17 Data Controls, all of them with the RecordsetType
"Dynaset". After loading and unloading the forms a few times, I get the
run-time error 3014, telling me that I can't open any more tables.
Those recordsets shouldn't be closed automaticly, when the form unloads?

Thank you in advance.

Pedro Vieira

In contrast, recordset objects with global scope, which is effectively
what those associated with 'global' form controls are, aren't known for
their 'garbage-safe' integrity. You have to ensure that all references
to such objects are torn down yourself. Setting the variable (the
object reference) to Nothing does this. Naturally, you should .Close
the recordset first (courtesy), but the setting to Nothing should do
this - as the object 'dies', it should .Close whatever it's got.

In *principle*, when a form is unloaded, all of these controls,
specifically the data controls, should get dereferenced and die
gracefully. However, there seems to be some evidence that this
does not always happen. I tend to avoid data controls for this
reason. My avoidance of such may be more to do with myth and
legend than actuality, but I find that direct DAO programming
allows me to take care of my own quality control in this regard.