MDE Compile and Access Crashing Issue

[remove.redvicar]

Hi all,

I know there are quite a few posts / knowledge base / articles around
dealing with turning an MDB -> MDE and it crashing ('Microsoft has
encountered a problem), however none of the solutions appear to work
for me. In particular, the two main ones I've tried are the MS
Knowledgebase (http://support.microsoft.com/kb/814858) and an article
from everythingaccess.com (http://www.everythingaccess.com/
tutorials.asp?ID=0).

The database is not large, and contains very little code. It's used in
a Call Centre to measure quality. Consists of three forms (one for
each Call Centre). Each form has a number of yes / no boxes. All the
code does is on-update recalculates the score based on the yes / no.
Only other code is using MouseHook.dll. All code is on the front end,
none of the backend.

There are six users and it's a split DB. It runs perfectly as a MDB.

I've tried the above decompile / recompile both on the network drive
and locally, and on two different PCs, however it doesn't fix it. I'm
unsure what troubleshooting steps to take from here, what I should be
looking for. As I say it's not a big DB so if the quickest method is
something list spending a couple of hours copying / pasting the forms
and modules into a 'new' DB and re-linking to the backend I'm happy to
do that (but would it fix it?).

All thoughts appreciated!

Details:
Access 2002 10.1302.4219 SP-2
Front End size ~11 meg
Backend seix ~3 meg

Dicky

 

['69 Camaro]

Hi.

I know there are quite a few posts / knowledge base / articles around
dealing with turning an MDB -> MDE and it crashing

Have you checked the "Can't make an MDE!" checklist on the following Web
page?

http://www.Access.QBuilt.com/html/conversion.html

If so, create a new MDB file and import the front end into it, compile the
code, compact it, and then try to convert the new file into an MDE.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.