G
Guest
I'm getting the lovely "Microsoft was unable to create an MDE database"
message..
I only use Access 2000, I have gone through this check off list and
everything seems correct. I've made this mdb into an mde before. The mdb
Access application has linked tables to an SQL server, also linked tables to
another Access application. I have refreshed all the links...
I don't know what else to check...
Could someone please help me out.
Does the code compile? (This is the most common reason for failing to create
the MDE format.)
///// YES EVERYTHING COMPILES FINE /////
Is the database format the same version of Access as that being used to
create the MDE? (For example, the default database format for Access XP and
2003 is 2000, but one needs to convert the database to the current version
before making an MDE database out of the MDB database.)
//// EVERYTHING IS ACCESS2000/////
Do you have sufficient permissions on the Windows directory where the MDE
file is going to be created? (Read, create, and modify)
/// YES AND I'VE TRIED OTHER DIRECTORIES EVEN MY C: DRIVE AND I GET THE SAME
ERROR/////
If the database is secured using user-level security, are you currently
logged in as the owner of the database, or at least a member of the Admins
group? (For best results, make sure that you are logged into the workgroup as
the owner of the database. Being a member of the Admins group will usually
work, but not always.)
/// I'M IN THE ADMIN GROUP AND HAVE MADE THE MDE BEFORE ////
If you aren't the owner of the database, do you have sufficient user-level
permissions? (Open/run database, open exclusive, modify design or administer
for all tables, and read design permissions for all objects.)
/// I DID OPEN IT EXCLUSIVELY AND GET THE SAME ERROR////
Do you have exclusive access to the MDB file? (You can open the database
file in shared mode, but no other user or process can be using the database
while you create the MDE database. To prevent interference from others, you
may want to open the MDB file in exclusive mode, but this isn't required.)
/// I DID OPEN IT EXCLUSIVELY AND GET THE SAME ERROR////
Is there sufficient disk space available for the new MDE file?
//// YES ///
Are you attempting to create an MDE from Access 2000, but with applications
from Microsoft Office XP, or Microsoft Office 2003, or Microsoft Visio 2002
also installed on the computer, but without Microsoft Office 2000 Service
Packs 1, 2 and 3 already installed?
//// NO EVERYTHING IS ACCESS2000 ////
Is the database no longer replicated, if it once was?
/// NO ///
If there's a VBA password, have you already opened the VB Editor with that
password so that the code is accessible?
/// NO VBA PASSWORDS ///
If this database references other Access databases as libraries, have they
all been converted to MDE files already, including any that are part of a
chain of library databases?
/// NO OTHER ACCESS
If this database references other Access databases as libraries, and if you
aren't the owner of those database libraries, do you have sufficient
user-level permissions? (Open/run database and read design permissions for
all objects)
//// YES IT DOES BUT I HAVE SUFFICIENT USER-LEVEL///
If this database references other Access databases as libraries, do you have
sufficient permissions on the Windows directory where the library MDE files
are located? (Read, create, and modify)
//// YES IT DOES BUT I HAVE SUFFICIENT USER-LEVEL///
If this database uses external tables as data sources, are all of the
connection strings valid? (Linked tables, VBA code, connection strings for
data sources of database objects, including valid user ID's and passwords and
valid database passwords.)
/// YES IT DOES LINK TO ANOTHER ACCESS db - I UPDATED ALL THE LINKS FINE//
Does this database have a reasonable number of database objects that each
require a TableID (tables, linked tables, bound forms, queries, reports,
record sets, et cetera), so that the added TableID's required to make the MDE
database file don't exceed 2048 for Jet 3.51 and 4.0 (or 1024 TableID's for
Jet 3.0 and 3.5)? (There's no way to be precise, but try to count one
TableID for each table, each query, each table mentioned in the SQL statement
of each query, each bound form, each bound combo box, each bound list box,
each report, each recordset, and each table mentioned in the SQL statement of
each recordset; two TableID's for each linked table and each
master/child-linked subform.)
/// YES ///// AGAIN - I'VE BEEN ABLE TO MAKE THIS mdb INTO AN mde A FEW
WEEKS AGO///
Do any forms or reports contain ActiveX controls? Does the ActiveX control
version used to create the control on the form or report currently exist on
the computer that is trying to create the MDE file? Is this version
registered in the Windows Registry? (Upgraded versions of ActiveX controls
will often prevent the MDE creation, due to incompatibilities with the
previous version.)
//// NOT USING ANY ACTIVEX CONTROLS/////
message..
I only use Access 2000, I have gone through this check off list and
everything seems correct. I've made this mdb into an mde before. The mdb
Access application has linked tables to an SQL server, also linked tables to
another Access application. I have refreshed all the links...
I don't know what else to check...
Could someone please help me out.
Does the code compile? (This is the most common reason for failing to create
the MDE format.)
///// YES EVERYTHING COMPILES FINE /////
Is the database format the same version of Access as that being used to
create the MDE? (For example, the default database format for Access XP and
2003 is 2000, but one needs to convert the database to the current version
before making an MDE database out of the MDB database.)
//// EVERYTHING IS ACCESS2000/////
Do you have sufficient permissions on the Windows directory where the MDE
file is going to be created? (Read, create, and modify)
/// YES AND I'VE TRIED OTHER DIRECTORIES EVEN MY C: DRIVE AND I GET THE SAME
ERROR/////
If the database is secured using user-level security, are you currently
logged in as the owner of the database, or at least a member of the Admins
group? (For best results, make sure that you are logged into the workgroup as
the owner of the database. Being a member of the Admins group will usually
work, but not always.)
/// I'M IN THE ADMIN GROUP AND HAVE MADE THE MDE BEFORE ////
If you aren't the owner of the database, do you have sufficient user-level
permissions? (Open/run database, open exclusive, modify design or administer
for all tables, and read design permissions for all objects.)
/// I DID OPEN IT EXCLUSIVELY AND GET THE SAME ERROR////
Do you have exclusive access to the MDB file? (You can open the database
file in shared mode, but no other user or process can be using the database
while you create the MDE database. To prevent interference from others, you
may want to open the MDB file in exclusive mode, but this isn't required.)
/// I DID OPEN IT EXCLUSIVELY AND GET THE SAME ERROR////
Is there sufficient disk space available for the new MDE file?
//// YES ///
Are you attempting to create an MDE from Access 2000, but with applications
from Microsoft Office XP, or Microsoft Office 2003, or Microsoft Visio 2002
also installed on the computer, but without Microsoft Office 2000 Service
Packs 1, 2 and 3 already installed?
//// NO EVERYTHING IS ACCESS2000 ////
Is the database no longer replicated, if it once was?
/// NO ///
If there's a VBA password, have you already opened the VB Editor with that
password so that the code is accessible?
/// NO VBA PASSWORDS ///
If this database references other Access databases as libraries, have they
all been converted to MDE files already, including any that are part of a
chain of library databases?
/// NO OTHER ACCESS
If this database references other Access databases as libraries, and if you
aren't the owner of those database libraries, do you have sufficient
user-level permissions? (Open/run database and read design permissions for
all objects)
//// YES IT DOES BUT I HAVE SUFFICIENT USER-LEVEL///
If this database references other Access databases as libraries, do you have
sufficient permissions on the Windows directory where the library MDE files
are located? (Read, create, and modify)
//// YES IT DOES BUT I HAVE SUFFICIENT USER-LEVEL///
If this database uses external tables as data sources, are all of the
connection strings valid? (Linked tables, VBA code, connection strings for
data sources of database objects, including valid user ID's and passwords and
valid database passwords.)
/// YES IT DOES LINK TO ANOTHER ACCESS db - I UPDATED ALL THE LINKS FINE//
Does this database have a reasonable number of database objects that each
require a TableID (tables, linked tables, bound forms, queries, reports,
record sets, et cetera), so that the added TableID's required to make the MDE
database file don't exceed 2048 for Jet 3.51 and 4.0 (or 1024 TableID's for
Jet 3.0 and 3.5)? (There's no way to be precise, but try to count one
TableID for each table, each query, each table mentioned in the SQL statement
of each query, each bound form, each bound combo box, each bound list box,
each report, each recordset, and each table mentioned in the SQL statement of
each recordset; two TableID's for each linked table and each
master/child-linked subform.)
/// YES ///// AGAIN - I'VE BEEN ABLE TO MAKE THIS mdb INTO AN mde A FEW
WEEKS AGO///
Do any forms or reports contain ActiveX controls? Does the ActiveX control
version used to create the control on the form or report currently exist on
the computer that is trying to create the MDE file? Is this version
registered in the Windows Registry? (Upgraded versions of ActiveX controls
will often prevent the MDE creation, due to incompatibilities with the
previous version.)
//// NOT USING ANY ACTIVEX CONTROLS/////