ADP/ADE files

D

Dennis

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!
 
D

Dennis

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

???
 
D

Dennis

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.
 
S

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...
 
S

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.
 
D

Dennis

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

Dennis

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

Dennis
 
Top