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
Last Comment
LSpiker
ASKER CERTIFIED SOLUTION
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
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 questionASKER
OK let me try that and I'll get back to you. The switchboard has a lot of functionality on load.
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
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
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
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 questionASKER
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
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.
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
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.