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 16th, 2003, 01:16 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 Vague Error Message When Creating MDE

Here's one for the vague files... I have a very simple Access XP (2002) MDB that I wish to turn into an MDE. I get this only error message: "Microsoft Access was unable to create an MDE database." That's it. No reasons why... nothing. The VBA code in the database's form compiles correctly (no errors in any controls). There are no linked tables. It's a very straightforward table/query/form/report MDB file. Any clues?

(I hate unhelpful error messages!) :(

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
 
Old October 16th, 2003, 02:22 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

All Micfoshaft Winblows error messages are useless!

Just because this happende to me. Is your MS Access 2002 opening a mdb file that was created with
Access 2000? maybe it is opening the file as Acess 2000.
Other than that try this.

_________________
-go to the Start menu
-select Run
-type in
         msaccess.exe /decompile

     This will open MS Access
-From the file menu select the file you wish to compile and open it
-go to a form that contains code and open it in design view
-open the code module
-go to the Debug menu
-Select compile
        if the file does not compile, fix or remove any bad code.
After the compile is done, save all the modules (clicking save once ussially is sufficient)
Save any forms if prompted.
Close Access, re-open the file and compact and repair

This will decrease absolutely all the empty spaces in your database front end.
___________



Sal
 
Old October 16th, 2003, 03:47 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

Quote:
quote:Originally posted by sal
Is your MS Access 2002 opening a mdb file that was created with
Access 2000? maybe it is opening the file as Acess 2000.
Sal, the MDB was originally created with Access '97 and converted into an Access XP (2002) format. When Access opens it, indeed, opens as a 2002 format.

Quote:
quote:-go to the Start menu
-select Run
-type in
         msaccess.exe /decompile

     This will open MS Access
-From the file menu select the file you wish to compile and open it
-go to a form that contains code and open it in design view
-open the code module
-go to the Debug menu
Check... got this far. :)

Quote:
quote:-Select compile
That option is grayed out. D'OH!


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old October 16th, 2003, 03:52 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The option gets grayed out right after a compile. You probably already did that.
Do this, open a form and make a change to the code. Then insert a blank line in between two lines of code. after you do that you no longer have a compiled database.

then try decompiling again.
Hope it works, make sure you do a backup before you decompile.

Sal
 
Old October 17th, 2003, 07:49 AM
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

Sal,

Success! Thank you. :D


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the error message for a 500 server error? chobo2 C# 2005 1 May 4th, 2008 03:11 AM
Help - Shared MDE - Exclusive Access message box surajguru Access 3 February 22nd, 2007 12:18 PM
.mde problem Derek_05 Access 4 September 20th, 2006 07:38 PM
Warning Message when creating Outlook email Paulsh Access VBA 3 September 5th, 2005 06:27 AM
connection problem, vague message bani ADO.NET 0 September 20th, 2003 09:31 AM





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