Access97 .MDE

[Chris]

Ok...

I wrote an Access 97 Database and made a .MDE database file which has been
in operatoin for 9 years! Working great being backed-up every night... Now,
the computer just crashed, harddrive fried and I had to put another machine
into it's place. The machine I put into it's place has Office 2000 Premium.
Now, I can't open or enable or convert the .MDE database to even be able to
run in Access2000. Here's the kicker... I do not have the original MDB file
nor do I have a copy of Access 97 to load so that I can continue to use the
Database.

My questions:
1) Is there anyway to get the Access97 to load in Access 2000?
2) How do I go about obtaining a copy of Access 97? Would Microsoft allow me
to purchase it directly?

 

[Norman Yuan]

Your problem is you do not have the *.mdb version of your app, so you cannot
tell what is wrong with the app in *.mde.

In general, there should not be a problem to use Access2K/2/3 to run Access
app built on Access97, especially the file has been compiled to *.mde,
meaning there should not be syntex error in the code ( I did run into an
Access97 app in *.mdb, that has duplicated function/procedure in code, which
prevent my Access2003 to run it. However, it runs fine with Access97. I had
to fixed that code so that Access2003 can run it). Rather, your problem
could be the that your app used some out-of-date component that was
presented in the old computer, but not avaalable on the newer computer.
Since you do not have the *mdb version, you could not degug the app to find
out exactly wrong. It is critical to keep a *.mdb version of *.mde.

Sorry for not able to give a solution.

 

[Rick Brandt]

Your problem is you do not have the *.mdb version of your app, so you
cannot tell what is wrong with the app in *.mde.

In general, there should not be a problem to use Access2K/2/3 to run
Access app built on Access97, especially the file has been compiled
to *.mde, [snip]

An Access 97 MDE can only be opened with Access 97. None of the newer versions
will be able to open it. MDB could be opened by 2000 or higher, but not MDE.

 

['69 Camaro]

Hi, Chris.

I wrote an Access 97 Database and made a .MDE database file which has been
in operatoin for 9 years!

That's pretty impressive -- and one of the reasons Microsoft has had such a
hard time convincing customers to upgrade to newer versions. Access 97
applications, when built and used correctly, were very stable.

Working great being backed-up every night

The administrators lied to you. The MDB file hasn't been backed up in a
long time. And the computer wasn't backed up after the software applications
were loaded, either.

1) Is there anyway to get the Access97 to load in Access 2000?

Nope. Only Access 97 can run Access 97 MDE files. However, the tables and
queries can be imported into a new Access 2000 database file. (Probably
macros, too, but I don't remember.)

2) How do I go about obtaining a copy of Access 97? Would Microsoft allow me
to purchase it directly?

Microsoft stopped selling Access 97 a very long time ago. You'll need to
find someone who will sell you their copy of Access 97. You may find links
to some businesses that carry recycled software in the "Old versions of
Access and Office Developer tools" section of the following Web page:

http://www.Access.QBuilt.com/html/links.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[david epsom dot com dot au]

Ok...

I wrote an Access 97 Database and made a .MDE database file which has been
in operatoin for 9 years! Working great being backed-up every night...
Now,
the computer just crashed, harddrive fried and I had to put another
machine
into it's place. The machine I put into it's place has Office 2000
Premium.
Now, I can't open or enable or convert the .MDE database to even be able
to
run in Access2000. Here's the kicker... I do not have the original MDB
file
nor do I have a copy of Access 97 to load so that I can continue to use
the
Database.

My questions:
1) Is there anyway to get the Access97 to load in Access 2000?
2) How do I go about obtaining a copy of Access 97? Would Microsoft allow
me
to purchase it directly?

MS doesn't sell A97 any more. You can look for a second hand copy
(perhaps eBay). Or you can find an application that is distributed
with the A97 runtime version.

A97 used VBA5. A2000 does not use VBA5. There is no way
A2000 can run an A97 application. But you can link to any
tables in the A97 database.

(david)

 

['69 Camaro]

Hi, Chris.

Do you perchance have an underground storage tank? The reason I'm asking is
that the EPA has an Access 97 database application available for download for
tracking underground storage tank information. It comes with the Access 97
Runtime, so that those who don't have Access can still run the database
program. Of course, any Access 97 MDE database application will run in this
Runtime version, too. Check the links in the "Access Runtime versions"
section of the same Web page I gave you earlier.

Since you already have Access 2000 loaded on this computer, I suggest you
either install the underground storage tank database on another computer that
doesn't have Access loaded, or else uninstall Access 2000 from this computer,
install the underground storage tank database with the Access 97 Runtime,
install the service packs, then reinstall Access 2000. This assumes you have
underground storage tank information that you need to track, of course.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[Tony Toews]

This assumes you have
underground storage tank information that you need to track, of course.

<chuckle>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm