Hello again,
I have another question concerning about the delete and set to nothing for a variable at the end of its life.
For example, in your book (chapter 6 using DAO to Access Data page 139, line 6)
varPKey = GetPrimaryKey(tdf)
why don’t you set varPKey = Nothing like the other variables (idx, tdf, dbs)

I don't have a copy of this book (yet), but (from my experience) ...

Object Variables:
Must be defined using the Dim command
    Dim dbs as Database
Must be defined using the Set command
    Set dbs=currentdb()
Object variables should be set to Nothing to free up all memory and system resources associated with the object
    Set dbs=Nothing

Non-Object Variables
Must be defined using the Dim command
    Dim varPKey as Variant
Must be defined using the Dim command
    varPKey = GetPrimaryKey(tdf)
Non-object variables memory issues are based on the how the variable was defined (i.e., local, private or public in scope)

In you post it appears that varPKey is a non-object variable of type variant. If that variable was defined within a Sub procedure, the value of varPKey will be lost once the Sub procedure ends.

Hope this helps ...

Terry Waltz

vubinhsg,

As Terry correctly suggests, you only explicitly destroy object variables. In the case you cite, varPKey is not an object variable because GetPrimaryKey does not return an object - it returns a string in a variant datatype.

Regards,
Graham R Seach
Microsoft Access MVP

Graham R Seach
Microsoft Access MVP