Access won't close

  • Thread starter Thread starter wimsan
  • Start date Start date
W

wimsan

Hi,

i have an access application that will not close after the execution of some
code (both both part of a form and in a function module.).
The code does open some recordsets but as far as i can see it closes them as
well.
Is there a way to find out what's preventing Access from closing ?

thanks in advance for a quick answer

regards,
Wim
 
Hi Wimsam,

not only should you close it, but also destroy the reference:

YourRst.Close
YourDB.Close
Set YourRst = Nothing
Set YourDB = Nothing

Luiz Cláudio C. V. Rocha
São Paulo - Brazil
 
wimsan said:
i have an access application that will not close after the execution of some
code (both both part of a form and in a function module.).
Click to expand...

Access minimizes to Windows 95/NT toolbar instead of closing
http://www.mvps.org/access/bugs/bugs0005.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top