[AccessD] Access Reopens?!?

Dan

...when all else fails, I use this ...it gets rid of all the residue that MS 
leaves floating around in your mdb ...it has saved my butt many times when 
strange things suddenly started happening..
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='EATBloatV2.mdb'

William Hindman

----- Original Message ----- 
From: "Dan Waters" <dwaters at usinternet.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, March 06, 2007 3:06 PM
Subject: [AccessD] Access Reopens?!?


>
> Hello Everyone,
>
> I have a database right now that is exhibiting strange behavior.  This is 
> a
> FE/BE database with a library mdb referenced by the FE.
>
> When I take a certain action, the database will shutdown normally, but 
> then
> the library mdb will open at a certain place in a certain procedure and a
> form, designed as a messagebox with colored buttons, opens to ask me a
> question.  On that form I can usually click one of the two buttons, but in
> this particular sequence the form is unresponsive.  And when this form
> opens, there is no Access window, just the form on the PC desktop.  When
> this happens, I go to task manager, but Access doesn't show as one of the
> running applications.  MS Access does show as one of the running 
> processes,
> and when I close that process the unresponsive form will close.  This is
> completely repeatable, and is happening on my PC and on a client's system.
>
> This particular code has worked fine for at least a year, and I don't know
> what I might have done to change it.
>
> I've already imported all the objects into a new database for both the FE
> and library, but that didn't fix it.  My next step is to comment out all 
> the
> code in both databases, decompile, compile, compact & repair, and then
> import all the objects into new databases (this will take hours!).
>
> Does anyone have any magic tricks to find or fix something like this?
>
> Thanks!
> Dan Waters
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>