Create MDE Files

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

I have a Access-2000 frontend application with SQL
backend. I have made many MDE files from my master file,
but now the Create MDE selection is not enabled. What do
I need to do to enable this?
 
Did you upgrade to Access 2002 or 2003? If so, you cannot create a .MDE file using the
2000 format. You'll have to convert the database to the newer format.
_____________________________________


I have a Access-2000 frontend application with SQL
backend. I have made many MDE files from my master file,
but now the Create MDE selection is not enabled. What do
I need to do to enable this?
 
I haven't upgraded, but I have tried to convert to the
newer version and create the MDE. The system always ends
up crashing.
-----Original Message-----
Did you upgrade to Access 2002 or 2003? If so, you
Click to expand...
cannot create a .MDE file using the
 
What do you mean by "always ends up crashing"? You indicated in your first post that "the
Create MDE selection is not enabled". How can it always crash, if it isn't even enabled?

If you are getting part way through the process of creating an MDE file, but it doesn't
succeed, then you probably have a compile error. Open any code module and click on Debug
Compile DatabaseName. Fix all compile errors before attempting to create a .MDE file.
Click to expand...
Also, make sure that you have Option Explicit shown at the top of all code modules
(usually as the 2nd line of code).
_____________________________________


I haven't upgraded, but I have tried to convert to the newer version and create the MDE.
The system always ends up crashing.
_____________________________________


Did you upgrade to Access 2002 or 2003? If so, you cannot create a .MDE file using the
2000 format. You'll have to convert the database to the newer format.
_____________________________________

message
I have a Access-2000 frontend application with SQLbackend. I have made many MDE files
from my master file, but now the Create MDE selection is not enabled. What do I need to
do to enable this?
 
Sorry for the confusion. The Selection is not enabled. I
convert the database to ACCESS 2002 and the selection
becomes enabled, but when I go to create an MDE it crashes.


-----Original Message-----
What do you mean by "always ends up crashing"? You
Click to expand...
indicated in your first post that "the
Create MDE selection is not enabled". How can it always
Click to expand...
crash, if it isn't even enabled?
If you are getting part way through the process of
Click to expand...
creating an MDE file, but it doesn't
succeed, then you probably have a compile error. Open
Click to expand...
any code module and click on Debugattempting to create a .MDE file.
Also, make sure that you have Option Explicit shown at the top of all code modules
(usually as the 2nd line of code).
_____________________________________


I haven't upgraded, but I have tried to convert to the
Click to expand...
newer version and create the MDE.
The system always ends up crashing.
_____________________________________


Did you upgrade to Access 2002 or 2003? If so, you
Click to expand...
cannot create a .MDE file using the
2000 format. You'll have to convert the database to the newer format.
_____________________________________

message
I have a Access-2000 frontend application with
Click to expand...
SQLbackend. I have made many MDE files
from my master file, but now the Create MDE selection is
Click to expand...
not enabled. What do I need to
 
Open any module in the Access 2002 version. Click on Debug > Compile DatabaseName. Do
you receive any compile errors? If so, you must fix these first, before a .MDE file can
be created. The reason for this is that the canonical (human readable) form of all VBA
code is removed. Only the compiled "P" code is retained. Thus, if you have a compile
error, it cannot save compiled code.

The fact that the menu choice was grayed out when your database was in the Access 2000
format is by design.

If your database compiles properly, and you still are having problems creating a .MDE
file, then please post back.

Tom
_________________________________________


Sorry for the confusion. The Selection is not enabled. I
convert the database to ACCESS 2002 and the selection
becomes enabled, but when I go to create an MDE it crashes.

_________________________________________



What do you mean by "always ends up crashing"? You indicated in your first post that "the
Create MDE selection is not enabled". How can it always crash, if it isn't even enabled?

If you are getting part way through the process of creating an MDE file, but it doesn't
succeed, then you probably have a compile error. Open any code module and click on Debug
Compile DatabaseName. Fix all compile errors before attempting to create a .MDE file.
Click to expand...
Also, make sure that you have Option Explicit shown at the top of all code modules
(usually as the 2nd line of code).
_____________________________________


I haven't upgraded, but I have tried to convert to the newer version and create the MDE.
The system always ends up crashing.
_____________________________________

"Tom Wickerath" <[email protected]>
wrote in message
Did you upgrade to Access 2002 or 2003? If so, you cannot create a .MDE file using the
2000 format. You'll have to convert the database to the newer format.
_____________________________________

message
I have a Access-2000 frontend application with SQLbackend. I have made many MDE files
from my master file, but now the Create MDE selection is not enabled. What do I need to
do to enable this?
 
Back
Top