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/ex...ributors2.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.
"'69 Camaro" wrote:
> 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/ex...ributors2.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.
>
>
> "Chris" wrote:
>
> > 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?
Similar Threads
