Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 29th, 2004, 10:44 PM
Authorized User
 
Join Date: Sep 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Unable to create an MDE database

Dear Experts,
I have the book Access 2003 VBA Programmer's Reference on my hand. I followed every steps on page 484 to 487 in trying to create an MDE file but failed. It looks smooth in beginning and at the end prompted dialog box "Microsoft Access was unable to create an MDE database.". Can you give me a help?


Thanks and Best Regards,
martinaccess :D:D:D



 
Old November 2nd, 2004, 05:12 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Open any form you have and then open any event procedure you have on the form. From there, compile the the database (Debug > Compile Database). Correct any errors you may encounter, save, and then try to make the MDE again.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old November 6th, 2004, 11:23 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi martinaccess,

Sorry for the delayed response.

SerranoG is correct about the compile. Another problem could be that your database is corrupt.

Another way to explain how to check the compile problem is for you to go to the Visual Basic Editor and select the menu option: Debug | Compile. If the compiler finds errors, you'll need to fix those and save your changes.

A quick way to determine if your database is corrupt is to Compact and Repair the database. I recommend that you make a backup of your database before you try this. This method does not guarantee that your database is not corrupt. It will only be an indication that it is.

If your database is corrupt, the simplest way to fix this is to create a new database and import all the objects from your database. When you create the empty database, be sure that it is Access 2002-2003 format before you begin importing objects. You can default the format for new databases by selecting "Tools | Options...". Go to the "Advanced" tab and select "Access 2002-2003"
for the "Default File Format".

If you find you still have problems creating an MDE from this new database, you may have one object that is corrupt beyond repair by this import technique. To find that object you'll need to create another new database and import objects, more or less, one at a time until you find the one that causes the compile to fail. Usually the problem will be in a form or report.

I hope these ideas help. If not, perhaps you could describe more about the things you have tried.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
membership@pnwadg.org





Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to create database. rupen SQL Server 2005 4 December 6th, 2007 02:39 AM
Unable to create Macro valdetero Excel VBA 0 July 26th, 2007 02:58 PM
Unable to create an RELAXNG schemaFactory kapar_p XML 0 August 8th, 2006 08:08 AM
Trying to create MDE file sburgess Access 1 February 1st, 2005 05:44 PM
Unable to create Excel object neha_jn Beginning VB 6 1 September 28th, 2004 10:06 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.