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?
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.
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.
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).
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.