Closeing Access 97

  • Thread starter Thread starter MarkS
  • Start date Start date
M

MarkS

Hi,
I use a macro to update a table with data from several sources. after runing
it I can close the data base but I can't close access itself.

any sugestions

MarkS
 
MarkS said:
I use a macro to update a table with data from several sources. after runing
it I can close the data base but I can't close access itself.


That usually happens because an object variable was not
closed/cleared. Check to make sure that you close what you
open and set every object variable to Nothing when you are
done using it.

There was also a bug in code like:
If checkbox Then
that would leave the checkbox object hanging around. This
had several simple workarounds:
If checkbox.Value Then
or
If checkbox = True Then
or
If (checkbox) Then
 
Back
Top