Re: Making an MDE file in Access 2002

#1

Answered elsewhere

DON'T MULTI-POST! (ie. send copies of the same message seperately to
different newsgroups) When you do that, no-one can see any replies that you
get in any of the other newsgroups.

Instead, *cross-post* (send the message simultaneously to different
newsgroups by naming all of them in the "Newsgroups" line). Then, readers of
*this* newsgroup would see the reply that I have already given you in
another newsgroup - so they wouldn't waste their time, replying again.

TC

"Todd D. Levy" <usenet001-tdlevy (AT) spamex (DOT) com> wrote

Quote:

I am running Access 2002 with a default database file format of Access
2000 for backward compatibility.

In the Tools - Database Utilities Menu the Make MDE File selection is
ghosted out (cannot be selected).

There is not much in the documentation, but what little I have found
suggests that Access 2002 can only create MDE files from databases that
are originally Access 2002 format, and cannot create MDE files from
databases in Access 2000 format.

Could something this stupid and annoying be true?

If so, how can I create and MDE file for an Access 2000 file format
database in Access 2002?

If not, why is this selection not available? Possibly a setting that
needs to be changed?

#2

Todd D. Levy <usenet001-tdlevy (AT) spamex (DOT) com> wrote in
news:MPG.1990fdc6508201359896b5 (AT) nyc (DOT) news.speakeasy.net:

Quote:

There is not much in the documentation, but what little I have found
suggests that Access 2002 can only create MDE files from databases that
are originally Access 2002 format, and cannot create MDE files from
Databases in Access 2000 format.

It seems that MDE files do not, cannot change their references, as MDB
files do and can.
A 2002 MDB, running in 2000 format, has a reference to AC2002, not to
AC2000. If this file were made into an MDE (it can be through Code, but not
through the UI) then it would run perfectly on a machine where AC2002 is
installed, But it would not, could not, run on a machine where AC2002 is
not installed.
And the reason for choosing 2000 file format is, I suspect, so that it will
run on a machine with only 2000 installed.
I think one needs to create 2000 MDEs/ADEs on in 2000.
I suppose someone might do something incredibly clever in fooling Access
2002 into making the reference to Access 2000 but if one could, it would
almost certainly mean that Access 2000 was available on the machine where
the MDE is created, and if it were, why bother doing something incredibly
clever, when one could just fire up Access 2000 and create the MDE there?

--
Lyle

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Making an MDE file in Access 2002

comp.databases.ms-access comp.databases.ms-access

Re: Making an MDE file in Access 2002 - 07-29-2003 , 08:14 PM

Re: Making an MDE file in Access 2002 - 07-30-2003 , 01:29 AM