Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 16th, 2003, 01:16 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
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
Reply With Quote
  #2 (permalink)  
Old October 16th, 2003, 02:22 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #3 (permalink)  
Old October 16th, 2003, 03:47 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
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
Reply With Quote
  #4 (permalink)  
Old October 16th, 2003, 03:52 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #5 (permalink)  
Old October 17th, 2003, 07:49 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:24 PM.


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