Access unable to create an MDE

[Jeff G]

I am getting this message when I try to make an MDE:

"Access unable to create an MDE database"

No error mesages or any other info is displayed. I
haven't had this trouble before. Then I added a form, a
couple reports, an create table query, modified a toolbar
and added a module. Now I am getting this message. This
database is a front end of a project with several linked
table to a back end. Any suggestions?

Thanks
Jeff G

 

[Douglas J. Steele]

Try compiling your application (under the Debug menu when you're in the VB
Editor). Often an application will have some error that doesn't manifest
itself while it's running

 

[Jeff G]

Bingo! Thanks

-----Original Message-----
Try compiling your application (under the Debug menu when you're in the VB
Editor). Often an application will have some error that doesn't manifest
itself while it's running

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.

 

['69 Camaro]

Hi, Jeff.

As Doug wrote, try compiling first, and then fix any compile errors. That's
the most common reason why Access produces this error message. If that
doesn't help, there are several other things can prevent Access from
creating an MDE file. Try the "Can't make an MDE!" checklist below:

Make sure that the answer to all of the following questions is "Yes":

1.) Does the code compile?

2.) 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 out of the MDB file.)

3.) Do you have sufficient permissions on the Windows directory where the
MDE file is going to be created? (Read, create, and modify)

4.) 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.)

5.) If you aren't the owner of the database, do you have sufficient
user-level permissions? (Open/run, open exclusive, modify design or
administer for all tables, and read design permissions for all objects)

6.) Is there sufficient disk space available for the new MDE file?

7.) Are you attempting to create an MDE from Access 2K, but with
applications from Office XP or Visio 2002 also installed on the computer,
and already have Office 2K Service Packs 1, 2 and 3 installed?

8.) Is the database no longer replicated, if it once was?

9.) If there's a VBA password, have you already opened the VB Editor with
that password so that the code is accessible?

10.) 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?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.