I've been having trouble with the MSAccess.exe process not quitting every time I close the database.
I know an object is not unloading somewhere along the line, but I can' just put my finger on it. The problem doesn't seem to follow any strict pattern.
I have used the Switchboard Manager to create a standard switchboard, and one thing I am unsure about is the VB code that is automatically created behind it.
The 'con' object is used as follows:
Set con = Application.CurrentProject.Connection
>>>> ' it is then closed by
con=nothing
What I don't understand is why is the con object not closed with:
con.close 'and then
set con=nothing ???
Could this be the source of my problem or am I missing the point here?
I know an object is not unloading somewhere along the line, but I can' just put my finger on it. The problem doesn't seem to follow any strict pattern.
I have used the Switchboard Manager to create a standard switchboard, and one thing I am unsure about is the VB code that is automatically created behind it.
The 'con' object is used as follows:
Set con = Application.CurrentProject.Connection
>>>> ' it is then closed by
con=nothing
What I don't understand is why is the con object not closed with:
con.close 'and then
set con=nothing ???
Could this be the source of my problem or am I missing the point here?