dbTalk Databases Forums  

Can Exit Access, System Locks up

comp.databases.ms-access comp.databases.ms-access


Discuss Can Exit Access, System Locks up in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michel
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.