Solved

Database is in an unrecognized format

Posted on 2003-11-05
2
340 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

760 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

19 Experts available now in Live!

Get 1:1 Help Now