Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Database is in an unrecognized format

Posted on 2003-11-05
2
Medium Priority
?
351 Views
Last Modified: 2008-01-09
I have a development system that has Access 97, Access 2000 and Access 2002 installed on it.  As long as I open the Access programs and then open the corresponding databases from within the Access programs, it works fine.  For one of the Access 2002 databases, I have an icon on the desktop that I double click on to open that Access application.  This works OK until I open either the Access 97 or Access 2000, close it and then try to double click on the Access 2002 database icon again.  It then gives me "the database is in an unrecognized format" error.  Obviously, the Access 2002 database application is trying to open the last Access program that was executed (Access 97 or Access 2000).  Access 2002 is installed in a different folder from the Access 97 and Access 2000.  Is there a way to make the right Access program load when the icon is double clicked?
0
Comment
Question by:cacomputerguy
[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 Comments
 
LVL 18

Accepted Solution

by:
bonjour-aut earned 750 total points
ID: 9690357
look at that tool:

http://www.access-training.com/HTML/DLSecureMDB.html

maybe it is a way to sort out your different versions.

Regards, Franz
0
 

Author Comment

by:cacomputerguy
ID: 9690684
With further investigation, I just created a new icon with the following target "C:\Program Files\Microsoft Office\Office10\msaccess.exe" "c:\My Application.MDE".  This loads Access 2002 from its default folder and then starts My Application.  Thanks for the advice.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

715 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