• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 699
  • Last Modified:

Error opening .mde file

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
Angel02
Asked:
Angel02
  • 4
  • 3
  • 2
2 Solutions
 
peter57rCommented:
You cannot use any form or
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
peter57rCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Angel02Author Commented:
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
 
peter57rCommented:
The mdb could be anywhere.  One would hope that the original developer placed the mdb in a safe but readily accessible location.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Angel02Author Commented:
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
 
peter57rCommented:
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
 
Angel02Author Commented:
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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now