Solved

Unrecognized database format

Posted on 2004-08-10
2
699 Views
Last Modified: 2012-08-13
I have Access 2003 as my development environment, have built a .mdb in Access 2000 file format, then I use the Startup Wizard in Access Developer Extentions to build a .mde.  When executing the .mde on a test machine with Access 2000, I get the message: "This database is an unrecognized format...."  What could be causing this, how can I troubleshoot?
0
Comment
Question by:cyberwarrior
[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
  • 2
2 Comments
 
LVL 85
ID: 11764026
You can't build a 2000 .mde file using that method. You MUST do this from with a MS Access 2000 session ... and you cannot do that natively from within Access 2003.
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 11764077
You could build you .mde on the Test machine, but make SURE it simulates your target environment (i.e. if your users are going to be running Windows 2000 OS, make sure you test machine is running the same, etc etc).  Or you could use some brand of Virtual Machine software - I use vmWare and find it extremely useful and stable ... I've also got a copy of Virtual PC from my MS Subscription, but have never tried it. If so, you can build your .mde file there ... otherwise, your .mde will always be saved in the 2003 format which, of course, you test machine with Access 2000 on it cannot read.

Also, make sure to import all objects to a new, blank database before building your .mde file ... and make sure to reset all database properties (you Startup props).
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

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.

Join & Ask a Question