Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
Course Of The Month
1 day, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
ACCDR in access 2010 not working but ACCDB is fine???
Posted on 2013-01-02
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
2- +1
10 Comments
Active today
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
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
Active today
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
Active today
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.
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.
Active today
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
Active today
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.
Active today
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
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
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Suggested Courses
Course of the Month1 day, 19 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.