Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

mde error

Discussion in 'Information Technology' started by Dan @BCBS, Jul 28, 2006.

Tags:
  1. Dan @BCBS

    Dan @BCBS
    Expand Collapse
    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/////
     
  2. Loading...

    Similar Threads Forum Date
    Ramdev deean yabhlleeahn..Nonsense of Ramdev PUNJABI Hard Talk Mar 12, 2014
    India Now, Ramdev backs Bluestar Memorial Breaking News Jul 6, 2012
    Hinduism Baba Ramdev Praises Guru Gobind Singh Interfaith Dialogues Apr 24, 2012
    India I Applaud Action Against Ramdev: Khushwant Singh Breaking News Jul 9, 2011
    India Ramdev Threatens Armed Rebellion, Govt Issues Stern Warning Breaking News Jun 8, 2011

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Have you tried starting it with the /DECOMPILE switch?
    If so export everything to a new DB (it is f**ked) - JetComp might fix it -
    but I doubt it

    HTH

    Pieter



    "Dan @BCBS" <DanBCBS@discussions.microsoft.com> wrote in message
    news:723F69D7-B390-4C27-A05A-1A04481D8BB7@microsoft.com...
    > 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/////
    >
    >
    >
    >
     
  4. Dan @BCBS

    Dan @BCBS
    Expand Collapse
    Guest

    I found another error when I compiled it again...
    Thanks

    "Pieter Wijnen" wrote:

    > Have you tried starting it with the /DECOMPILE switch?
    > If so export everything to a new DB (it is f**ked) - JetComp might fix it -
    > but I doubt it
    >
    > HTH
    >
    > Pieter
    >
    >
    >
    > "Dan @BCBS" <DanBCBS@discussions.microsoft.com> wrote in message
    > news:723F69D7-B390-4C27-A05A-1A04481D8BB7@microsoft.com...
    > > 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/////
    > >
    > >
    > >
    > >

    >
    >
    >
     

Share This Page