MDE Compile and Access Crashing Issue - Normal Fix Won't Fix

[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

 

[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

Not sure why that loaded twice - but please respond to this one!

Cheers

 

[SJ]

Sometimes we have a crash if some of the tables can not link correctly.
Say they are linked using a DSN on someones machine, but my machine doesn't
have that DSN.

The other day, the same thing happenned , i tracked it down to a passthru
query (in a report's recordsource) that was taking too long to run.

However we use ODBC DSN's to SQL Server.
The same inconvenient thing happens tho.

If it was me, id make sure that the front end can connect properly to the
back end.
Then i'd try removing objects until the thing created an MDE.

I presume it compiles OK.

Its usually a matter of removing objects until the thing works then tracking
down the issue in the problem object.