Link to home
Start Free TrialLog in
Avatar of LSpiker
LSpiker

asked on

ACCDR in access 2010 not working but ACCDB is fine???

This is interesting.  My accdb is working without a problem.  When I change my ACCDB to an ACCDE and then to ACCDR I get an error which says "Microsoft Access has stopped working" of course there is no way to debug.  When I open my ACCDB I get no errors what so ever.  Any ideas?
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LSpiker
LSpiker

ASKER

OK let me try that and I'll get back to you.  The switchboard has a lot of functionality on load.
Avatar of LSpiker

ASKER

I get the same result.  Also I already had error trapping in all the opening Events.
Is this occurring on the same machine  (as with DB) or a different machine?
If different, possibly there is a Reference error?

mx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LSpiker

ASKER

It is the same machine... I get the same error in a DE and DR however it does compile in DB.
RT issues are a bitch to troubleshoot - because you can't 'see' anything.  I would appear that ... an unexpected error is occurring some place where you do not have error trapping .. OR - worse - some sort of a Microsoft Bug - wherein it's not really generating an error - just shutting down!

mx
mx said it rather succinctly<g>

 Given that it compiles cleanly, I would:

1. Make a backup
2. Try decompile
3. Compile again and retest.

 If that fails, create a new DB container and import everything into it, compile, and try again.

If that still fails, then your probably tripping over an Access bug.

At that point, your only option is to find what's causing the problem and then work a round it.  You'll need to find the bug by placing msgboxes in the code at various points and narrow down when it dies (ie. starting up a specific form).

Jim.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LSpiker

ASKER

Thank you experts.  I found the problem.  I had a corrupted form that would compile.  After I removed it and imported a safety version of it the accdr worked fine.  The additional information was very helpful.