Solved

Database is in an unrecognized format

Posted on 2003-11-05
2
341 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
2 Comments
 
LVL 18

Accepted Solution

by:
bonjour-aut earned 250 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

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now