MDE file created in ACCESS 2000 ?

[Guest]

I converted a Access 2000 program to a MDE file, it seems to be working. My
understanding was that you could only do this In Access 2002-2003 file format
.. Is there something I am missing here, will it give me problems in the
future? --


Dennis B

 

[Guest]

Hi, Dennis.

I converted a Access 2000 program to a MDE file, it seems to be working. My
understanding was that you could only do this In Access 2002-2003 file format

Access 95 and newer versions can create MDE files from an MDB file. The
database file format must be in the same version as the Access application
that will create the MDE database file, unless one is an expert and knows how
to create MDE files in versions other than the current one installed on the
computer.

will it give me problems in the
future?

With any MDE file, it's possible to have library reference problems when the
file is run on computers other than the one that was used to create the MDE
database file. As a rule of thumb, if you've used more than just the default
libraries the MDE will work on your computer and any other computer which has
the same configuration (the same library versions and library paths). If
you've only used the default libraries, then the file should work just fine
in Access 2000 and later versions.

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.

 

[Guest]

Very Helpful!

Thanks,
--
Dennis B

Hi, Dennis.


Access 95 and newer versions can create MDE files from an MDB file. The
database file format must be in the same version as the Access application
that will create the MDE database file, unless one is an expert and knows how
to create MDE files in versions other than the current one installed on the
computer.


With any MDE file, it's possible to have library reference problems when the
file is run on computers other than the one that was used to create the MDE
database file. As a rule of thumb, if you've used more than just the default
libraries the MDE will work on your computer and any other computer which has
the same configuration (the same library versions and library paths). If
you've only used the default libraries, then the file should work just fine
in Access 2000 and later versions.

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.

 

['69 Camaro]

You're welcome!

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.

 

[George Nicholson]

My understanding was that you could only do this In Access 2002-2003 file

format ...

Not quite.
If the file format is Access 2000, you need Access 2000 to make it into an
MDE.
If the file format is Access 2002, you need Access 2002 to make it into an
MDE.
etc.

So, you can make any post-Access97 mdb file into an mde, *if* your version
of Access corresponds to the file format. Of course, in some cases, you can
convert the mdb file to whatever version of Access you have and then make an
mde.

HTH,