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

x
?
Solved

Unrecognized database format

Posted on 2004-08-10
2
Medium Priority
?
703 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 750 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

Technology Partners: 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 describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

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