WHY is my Database shutting down??!!

  • Thread starter Thread starter Bill Mitchell
  • Start date Start date
B

Bill Mitchell

I just changed a form from single to continuous. When I
open it it works fine but when i close it, the whole
database shuts down instantly - WHY?

Can anyone tell me?

This is bizarre.
 
Bill Mitchell said:
I just changed a form from single to continuous. When I
open it it works fine but when i close it, the whole
database shuts down instantly - WHY?

Can anyone tell me?

This is bizarre.
Click to expand...

Assuming you have no code that tells Access to quit, my best guess is
some sort of code corruption. You could try decompiling the project in
an attempt to clear out the corruption, by running a command line like
this:

msaccess /decompile "C:\Path To\YourDB.mdb"

(substituting your database's name and path, naturally). Make a backup
copy before doing this, in case it makes matters worse, rather than
better.

After decompiling the application, open it, compact it, compile it, and
compact it again. Then see if it still behaves the same way.

If that doesn't fix the problem, you could try exporting the form to a
text file, using the barely-documented Application.SaveAsText method,
and then deleting the form and reloading it from the text file using
Application.LoadFromText. Although these methods aren't documented in
the help file, if you start typing them in the Immediate window, the
intellisense popup and drop-down lists will tell you what the arguments
should be.
 
Thanks but neither of those work. Also, I tried creating
a brand new form and pasting the fields from the old form
into it - same bizarre result. God I hate stuff like
this.
 
Thanks but neither of those work. Also, I tried creating
a brand new form and pasting the fields from the old form
into it - same bizarre result. God I hate stuff like
this.
Click to expand...

Not to overlook the obvious, but you aren't maximizing this form and
accidentally clicking on the database close 'X' instead of the form
close 'X' are you?

Try using the command button wizard to add a command button which
closes your form. Does it experience the same behavior? Do you have
any code in Close or Deactivate or LostFocus events?


-D
 
Back
Top