You cannot convert an MDE. You must convert the MDB, then create a new MDE.

And MDEs do absolutely nothing for data: there's no reason for the back-end
to be an MDE.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"pieter" <news (AT) NOSPAM (DOT) internethoofdkantoor.nl> wrote

There is absolutely no benefit to converting a back-end (data-only) file to an
MDE file, so you might consider simply creating a new, blank MDB file and
importing all of the tables, along with their relationships, from the existing
back-end MDE and leaving it as an MDB.

--
Bruce M. Thompson, Microsoft Access MVP
bthmpson (AT) mvps (DOT) org (See the Access FAQ at http://www.mvps.org/access)

Hi,

I have an application written in Access 97. The front-end and back-end are
separated into two .mde files. I still have the original .mdb files.

The problem is: I want to convert the application to Access XP. The
front-end is no problem, but I'm worrying about the back-end: there has
been added much data to the .mde back-end. How do I convert it to Access
XP? It seems like Access XP can link to the A97 .mde and use it, but I
would rather convert the .mde to AXP as well.
Any tips on this?

Thanks in advance,

Pieter

"pieter" <news (AT) NOSPAM (DOT) internethoofdkantoor.nl> wrote

MDEs only prevent viewing and changing code-based objects. They do nothing to
protect Queries and Tables.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

On Mon, 03 Nov 2003 23:36:17 +0000, Douglas J. Steele wrote:

converted it to an MDE.

And does anyone know the reason why it's possible to use a linked MDE ,
while it's impossible to open the same MDE in a newer version of Access?

Regards,

Pieter

HI

Keep a backup of the original backend . . now rename the original ( add 97
to the end of the current name)
then try to open it in AXP. you will be asked if you want to convert or open
it

select to convert it and give the original name.

your front end should link to the backend AXP to AXP

dont worry about the amount of data . . AXP can handle it if 97 can . .
cheers paul

"pieter" <news (AT) NOSPAM (DOT) internethoofdkantoor.nl> wrote

On Mon, 03 Nov 2003 18:50:49 -0500, Bruce M. Thompson wrote:

But your suggestion works fine, thanks!

Regards,

Pieter

I've been guilty of that in the past (maybe even in the present!). <chuckle>

Glad to hear.

:-)
--
Bruce M. Thompson, Microsoft Access MVP
bthmpson (AT) mvps (DOT) org (See the Access FAQ at http://www.mvps.org/access)