Can Exit Access, System Locks up -
08-05-2003
, 02:36 PM
My application now almost works, except that now it will not close. I
am getting the ubiquitous hour glass, and in Windows Task Manager, it
tells me that Access is not responding. I have not even deployed the
app for multiple users yet but am using the so-called Access trick
that creates an another recordset object using a frmRsAlwaysOpen whose
Open Event contains the following code:
Set rsAlwaysOpen = currentDb().OpenRecordset("dummytable")
No errors are detected when the form opens, and the rs object is
correctly referenced in DAO 3.6. The form's Close Event is "Set
RsAlwaysOpen = Nothing."
I thought it might be a problem with the Access program itself or
something wrong with the file server it was on. So I moved the db to
the C:\ drive and tried it on another person's computer -- but Access
still locks up. In the code behind my Quit App button of my main form,
I instruct it to close all forms, even hiddens ones, and DoCmd.Quit.
I've tried coding it different ways, but it still locks up and won't
close. Thanks for any assistance.
-- Michel |