Solved

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

Posted on 2013-01-02
10
1,437 Views
Last Modified: 2013-01-03
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?
0
Comment
Question by:LSpiker
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 175 total points
ID: 38737466
One reason why robust error handling is necessary - *especially* if you are doing Run Times.

You can ... start your DB in RunTime mode using the /RunTime switch on the command line. This may ... expose the actual error - not sure, but probably not - since it emulates RT.  You will probably have to add some error handling any place you suspect an 'unexpected' error might occur.

mx
0
 

Author Comment

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

Author Comment

by:LSpiker
ID: 38737501
I get the same result.  Also I already had error trapping in all the opening Events.
0
 
LVL 75
ID: 38737559
Is this occurring on the same machine  (as with DB) or a different machine?
If different, possibly there is a Reference error?

mx
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 175 total points
ID: 38737687
Make sure the app compiles without errors.

Then rename to ACCDR and try it in runtime mode.

If that works, then convert it to a DE and see if that works as it should.

Jim.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:LSpiker
ID: 38737769
It is the same machine... I get the same error in a DE and DR however it does compile in DB.
0
 
LVL 75
ID: 38737810
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
0
 
LVL 57
ID: 38737943
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.
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 150 total points
ID: 38739642
Note too there are certain things you cannot do in the runtime, like open a form/report in design view. If you're doing these things, the error trapping may not work and you'll get the abrupt ending you're experiencing.

See this article:

http://msdn.microsoft.com/en-us/library/office/cc136539(v=office.12).aspx
http://msdn.microsoft.com/en-us/library/office/bb501030(v=office.12).aspx
0
 

Author Comment

by:LSpiker
ID: 38741318
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.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now