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?
Microsoft AccessMicrosoft Development

Avatar of undefined
Last Comment
LSpiker

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
LSpiker

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

ASKER
I get the same result.  Also I already had error trapping in all the opening Events.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Is this occurring on the same machine  (as with DB) or a different machine?
If different, possibly there is a Reference error?

mx
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
LSpiker

ASKER
It is the same machine... I get the same error in a DE and DR however it does compile in DB.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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
Jim Dettman (EE MVE)

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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.