Unrecognized Format

G

Guest

I have a friend who purchased an Access program from an independent
developer. The program has been used by my friend for several months and has
become a necessary and integral part of his business. However, my friend
requires additional reports to be generated from the tables in his database.
Unfortunately the original developer is no longer available and I have
volunteered to construct the reports for him. The front-end is an mde file
("app.mde") and the back-end is an mdb file ("data.mdb").

I cannot open either app.mde or data.mdb using Access 2000. Instead I get
the following error message when attempting to open either file.

"This database is in an unrecognized format"

I have several years experience designing applications with Access. However
I have never observed a problem of this nature. He has no problem using the
program on his system but I must be able to open the back-end file
("data.mdb") on my own machine in order to assist him.

The following command is being used to open his existing program.

"C:\Program Files\Common Files\Microsoft Shared\Access
Runtime\Office10\MSACCESS.EXE" /Runtime "c:\dbfiles\app.mde" /WrkGrp
"c:\dbfiles\Secure.mdw"

I certainly realize that I cannot modified the mde file on the front-end. I
intend to develop an alternative front-end program for him using his existing
mdb file as a back-end. It is important to use his existing back-end mdb
file because it contains too many records to attempt to reconstruct the
information into a new mdb file by simply reading individual records on his
existing forms and retyping while scrolling through the individual records.

If anyone can make any suggestions as to why I may not be able to open the
"data.mdb" file and how it might be corrected, I (and my friend) would
greatly appreciate such suggestions.

Thank you very much.
 
G

Guest

In the small print below I see "Office10". That is Access XP (aka Access
2002). If the developer used the Access 2002/2003 file format, you won't be
able to open it in Access 2000. Try a newer version of Office Professional.
 
G

Guest

Thanks Jerry.
I greatly appreciate your help. I will pursue your suggestion.
Jack Cannon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top