[AccessD] A2003 stops working

1. Done - no joy.
2. Done - no cigar.
3. Gotta try that - it's quick and easy.
4. Or, given the complexity (several tabs with subforms - lots of code) I
could resign from the client. As an alternative to sticking my head in the
oven. 
5. I think it's not that particular record - it's the delete.  However,
you're right in that I could permanently switch to DAO to do the delete.
Could be the fastest solution. 
6. Impractical - as this alternative was used multiple times many years ago.
There's a limit.  I'm pretty much there.

7. Although you did not suggest this - go away for two days and don't think
about it.  Which is what I'm doing tomorrow. 

Thanks for the ideas.

I'll post what works, eventually.

Rocky



 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Tuesday, July 26, 2011 4:22 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003 stops working

Have you tried swinging a lizard around your head three times?

I have had these mystery fails, and my general approach (stopping if/when I
have success) is:
1. Force a compile.
2. Decompile/recompile.
3. Build an empty database and import all objects from the old database.
4. Delete the form and rebuild it from scratch.
5. Rework the code.  In this case, open a dao recordset, find the record and
delete it with Recordset.Delete.
6. Tear my hair out.

I'm quite bald now.

Doug


On Tue, Jul 26, 2011 at 3:02 PM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:
> I just uninstalled O2010  - no effect - still craps out on the delete.
>
>
> R
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky 
> Smolin
> Sent: Tuesday, July 26, 2011 2:55 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] A2003 stops working
>
> Dear List:
>
> Running Access 2003 SP3 on a 64bit W7 OS machine.  From time to time 
> it stops with a message "Access has stopped working."
>
> I am getting it now consistently on one form on an app when deleting a 
> record (DoCmd.RunCommand acCmdDeleteRecord).
>
> I have Office 2010 loaded on this machine as well.
>
> Anyone have this happen?  Any cure?
>
> MTIA
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.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