[AccessD] Access Reopens?!?

...your reputation precedes you :))))

William Hindman

----- Original Message ----- 
From: "JWColby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 07, 2007 8:51 AM
Subject: Re: [AccessD] Access Reopens?!?


>I get an error going there.
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Wednesday, March 07, 2007 8:46 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Access Reopens?!?
>
> William,
>
> This certainly looks like a Magic Tool to me!
>
> I'll reply back to say how things worked.
>
> Thanks!
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Tuesday, March 06, 2007 4:17 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
>>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>