ADP/ADE files

[Guest]

Okay, I have an ADP file (first one I've ever dealt with). MS Help says to
"save as" an ADE file in order to keep the source code private. Well, I can't
find a place/way to SAVE AS an ADE file. I've looked through the FILE/SAVE AS
menu, but can't find an ADE option. What am I missing? Any help would sure be
appreciated.

Thanks!

 

[Sylvain Lafontaine]

Tools -> Make ADE File...

 

[Guest]

Sorry, but I don't see that option, either in the Access database
window/menu, nor in the VBA window/menu. (Access 2002).

???

 

[Danny J. Lesandrini]

Is your version of Access newer than the one the ADP was created in?

Recently I went to create an MDE and found the menu option missing.
Then I noticed the MDB was in Access 2000 format and I was using
Access 2003. If I wanted to make an MDE, I had to either us A 2K or
upsize the mdb. Maybe that's what's going on with you.

 

[Guest]

It's not an MDE I'm trying to create. It's an ADE.

MDBs are created from MDBs, and ADEas are created from ADPs. I've not worked
with ADPs before, so don't know how to make an ADE. As I said above, the MS
Help facility says to SAVE AS with a type = ADE. But I can't get that to work
for me. I don't have that option.

 

[Guest]

Sorry for the typo. MDEs are created from MDBs.

 

[Danny J. Lesandrini]

You didn't listen to me. I know you're working with an ADP making it
into an ADE, but don't you think that, perhaps, the same issue that
prevented the MDB from becoming an MDE would be worth investigating
in your case?

What version is your ADP and what version of Office are you working in?
If they don't match, you have a problem.


That having been said, have you looked on the Tools | Database Utilities
menu? That's where the Make MDE command is.

 

[Sylvain Lafontaine]

Oups, sorry: Tools -> Database Utilities -> Make ADE File; from the Access
database menu, not the VBA window menu.

This is for A2003, for A2002, I don't know but it should be the same.

Also, this option won't work from Access 2003 if the current database format
is A2000 and not in the A2002/2003 format. If this is the case, then you
must first convert it to the A2002/2003 format from the Tools -> Database
Utilities -> Convert Project...

 

[Sylvain Lafontaine]

Of course, the problem about the file format being A2000 instead of
A2002/2003 is the same for Access 2002 than for Access 2003.

Also, even if the MS Help make the suggestion of converting a file to the
MDE or ADE format, you must know that this has the requirement that all of
your users will share the same version of Access, Windows and Services
Packs; otherwise you might run into trouble.

 

[Guest]

I see. Just to make sure, I translated to A2002, and still can't see the
option. I'm at a loss.

 

[Guest]

That was it. I finally found it! Thanks to you (and Danny Lesandrini) for
your tips. You saved my butt!

Dennis