Is it possible to split an MDE file?

You can only split an MDB. If the developer didn't give your friend an MDB
version of the application, you're out of luck, since you can't convert an
MDE from version to version either.

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



"Grant Baxter" wrote in message
...
I'm helping a friend upgrade his office computers. He has an Access
d/b application on one of his computers. It's running Win95, and
Acess97. The developer changed the app into an MDE file which includes
the data and application code both. I would like to allow the
employees to run this app on the latest Access (which they have
purchased).

When I try to do a split within Access97, it seems to allow me to do
it. I end up with what look like the data file and the application
file. I then import the app file into AccessXP, and link it to the
data file. The app _seems_ to run correctly, except the data don't
match up with the data on the Access97 app. (some data is missing,
things that were in alphabetical order on Access97, are no longer
alphabetized in AccessXP, etc.)

Is what I'm trying to do (split the MDE on Access97, import the mdb
front end into AccessXP, and link the app to the mdb back end from the
Access97 split) possible?

My fallback is to keep them running the app on Access97 on the brand
new machine, which just doesn't sit right with me.

TIA,

grant

Grant Baxter wrote:
"Douglas J. Steele" wrote:

You can only split an MDB. If the developer didn't give your friend
an MDB version of the application, you're out of luck, since you
can't convert an MDE from version to version either.

If I could get a copy of the original MDB, how would I go about
getting the current data out of the current MDE?

grant

There is nothing that prevents splitting an MDE. If the wizard has some silly
reason to not allow it then just split it manually.

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