MDE problem

N

Niniel

Hello,

After I split my database into a front end and a backend, I wanted to create
an MDE from the front end for distribution to the client desktops. Yet every
time I run the MDE wizard, the Access crashes. I'm using Access 2002 with
A2000 data format, but even converting the db to A2002 format didn't make a
difference.
What I am wondering now is if there are things that are known to cause this
and that I need to check my db for, and then try to eliminate, or if it's
just a freak occurrance. It's not a life-and-death issue since I can always
use the MDB; I'm just curious why this is happening.

Thank you.
 
A

Allen Browne

A decompile will probably fix this but try this sequence as it deals with a
number of possible issues:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again. Close the database without running any code.

5. Create a new (blank) mdb in Access 2002 format. Before you do this, you
may need to set the Default File Format) under:
Tools | Options Advance.

6. Immediately turn off the Name AutoCorrect options.

7. Import everything from your old database:
File | Get External | Import

8. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

9. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

At this point, you should have a database where the name-autocorrect errors
are gone, the indexes are repaired, inconsistencies between the text- and
compiled-versions of the code are fixed, reference ambiguities are resolved,
and the code syntax is compilable.
 
D

David W. Fenton

Thank you, that did the trick.

To keep it running that way, I'd also suggest that you go to the
Options in the VBE window and turn off COMPILE ON DEMAND. This will
increase the stability of your VBA code compilation.
 
G

GerryS

As Niniel, I have also split an Access database (2003) I have previously
compiled the front end and packaged it with Access runtime - we've got about
half-a-dozen users. Following some upgrades, however, Access just hung
everytime I went for an mde with no error messages or any sort of log that
I'm aware of. I've never had the rename option turned on as I was suspicious
of it beforehand, but Allen's procedure has fixed the problem.

I'm curious now to find out whether there are any other useful command line
switches associated with Access. Does it all come through this sort of
forum, or is there some documentation hidden away somewhere?
 
M

Matt

I tried this but in my MDE the switchboard no longer pops up on startup. Any
suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top