making an mde file

[Guest]

I have completed my database.. and trying to convert it to an MDE file. but
on the tools menu, make MDE file option is disabled. I have tried everything
but no luck.
I have no idea why this is happening so I dont really know what input I
shuld give you.
My file is on the network. I thought this could be the problem. but I
created a simple database on my desktop, but still disabled.

Can anyone help me?

thanks

 

[Allen Browne]

1. Compiles?
You will not be able to make an MDE if the code does not compile.

2. Version?
If you use Access 2002 or 2003, and the file format is A2000, you must
convert before you can make an MDE.

3. Corruption?
Try decompiling a copy of the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

 

[Norman Yuan]

If your *.mdb file is not in the format of current Access version, the menu
to make *.mde/*ade is disabled. AccessXP and Access2003 set default file
format to Access2000. You must change it to AccessXp/Access2003 to make
*.mde. Of course, the *.mde can only run under the Access version or newer
version.

 

[Lynn Trapp]

You can only create MDE's for databases that are in the same version that
your application is. For example, if you have a 2000 database and are using
Access 2003 to try to create the MDE, the option will be disabled. If you
convert the file to your current application version, then you should be
able to do it.

 

[Eric J Owens]

I am in need of a little help with mde. In the MS Access help file, I meet
the requirements for creating an mde. But when i go and do so "Microsoft
was unable to create an MDE database". Being a network guy, I'm not sure
what is meant by the code compiling (from below). Most of my forms have
subs, and all seem to be working; there are no modules. I also ran the
decompile (suggestion from 3, below) and the db opened as normal without any
warnings or errors.

other info:

A2k mdb (trying to make mde using A2k)
SQL Server 7 backend

--
Regards,

Eric J Owens
AT&T Business Services/MasterCard LCM Team
(e-mail address removed)

 

[Lynn Trapp]

Well, there may be some little stray snippet of code hanging around that
doesn't prevent your form from running in an MDB, but it is preventing you
from creating the MDE. Go to the code window (Ctrl + G), then press Debug >
Compile [YourDatabasename]. It should take you to the offending code, which
you can either delete or fix.

 

[Eric J Owens]

BLESS YOU!!!!!! Thanks for the quick response, too!

--
Regards,

Eric J Owens
AT&T Business Services/MasterCard LCM Team
(e-mail address removed)

Well, there may be some little stray snippet of code hanging around that
doesn't prevent your form from running in an MDB, but it is preventing you
from creating the MDE. Go to the code window (Ctrl + G), then press Debug

Compile [YourDatabasename]. It should take you to the offending code, which
you can either delete or fix.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I am in need of a little help with mde. In the MS Access help file, I meet
the requirements for creating an mde. But when i go and do so "Microsoft
was unable to create an MDE database". Being a network guy, I'm not sure
what is meant by the code compiling (from below). Most of my forms have
subs, and all seem to be working; there are no modules. I also ran the
decompile (suggestion from 3, below) and the db opened as normal without
any
warnings or errors.

other info:

A2k mdb (trying to make mde using A2k)
SQL Server 7 backend

--
Regards,

Eric J Owens
AT&T Business Services/MasterCard LCM Team
(e-mail address removed)
file.
but