[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Error opening .mde file

Posted on 2013-01-07
9
Medium Priority
?
698 Views
Last Modified: 2013-01-17
The access database has .mde extension. It used to work fine but suddenly it stopped working. When I open it, it stays open for around 30 secs and then closes automatically. I held the Shift key and opened the .mde file but I am not getting an option to open the modules or forms in design view.
What could be wrong? How can I debug? Please advise.
0
Comment
Question by:Angel02
[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
9 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 38751883
You cannot use any form or
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 800 total points
ID: 38751891
You cannot open any objects in Design view in an .mde file. You need the source file (the .mdb file) in order to view objects in Design view.

There are many things that can cause a .mde file to end. Have you implemented full error handling? This is the first step in handling issues like this.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38751902
Sorry about my earlier mispost - the main point re design view has now been made by Scott.

If a working app stops working you have to be looking for anything that has changed- updates to WIndows or Office or any config changes.

But it's probably worth just re-creating a new mde and seeing if the problems go away.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:Angel02
ID: 38752819
Thank you for the responses. I don't think there is any proper error handling.
I am trying to find the corresponding .mdb file. Does the .mdb file have to be on the same server/network as the .mde or it can be on any remote machine?
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 1200 total points
ID: 38754599
The mdb could be anywhere.  One would hope that the original developer placed the mdb in a safe but readily accessible location.
0
 
LVL 85
ID: 38757295
And quite often the developer will provide you with ONLY the .mde file. If that's the case, then you're out of luck (except for this service: http://www.everythingaccess.com/mdeconversion.htm, which ain't cheap).
0
 

Author Comment

by:Angel02
ID: 38759712
One more question. Can the .mdb file have a different filename than the .mde? Is it possible for the developer to create an mde file and rename it? Will that work?
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38759765
Anything is possible , but it's a bit unlikely that the mdb name is not recognisable from the mde.
I have come across a case where the mdb file name included a version number (mydbV12.mdb) which was not carried into the mde (mydb.mde), but that's the only situation I have come across where the names are not the same.

Have you done a file  search just for *.mdb across all locations?  (I appreciate this might produce a long list)
0
 

Author Comment

by:Angel02
ID: 38788175
Well, we couldn't find the mdb anywhere. Looks like I'll need to create a new mdb now. Good luck to me!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

649 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