MDB works MDE Fails

[Ed Warren]

Ok, so this may not be a 'beginning' question. But I know there are people
out there with lots of experience and this one has me stumped!

Starting with a working and tested MS Access 97 application (*.mdb)

Converted it to MS Access 2002-2003 format. We are upgrading the user's
system to Office 2003 but want to use the runtime package for Access

It runs and tests out fine in Access 2003, and Access 2003 runtime (ok so
far)

Converted it to *.mde File

It runs and tests out fine in the full version of Access 2003, then things
get wierd

It fails in Access runtime!!! (throws unhandled exception, then exit)

Note the *.mdb file works fine in runtime.

I don't have enough hair left for this to be happening to me.

Ok to fully track this down I'll have to go through and make sure all my
code if fully error trapped (Back when I built this , five years ago, I
wasn't into complete error trapping).

If anyone has seen this before and solved it, I would greatly appreciate a
hint

Thanks,

Ed Warren.

 

[Rick Brandt]

Ok, so this may not be a 'beginning' question. But I know there are people
out there with lots of experience and this one has me stumped!

Starting with a working and tested MS Access 97 application (*.mdb)

Converted it to MS Access 2002-2003 format. We are upgrading the user's
system to Office 2003 but want to use the runtime package for Access

It runs and tests out fine in Access 2003, and Access 2003 runtime (ok so far)

Converted it to *.mde File

It runs and tests out fine in the full version of Access 2003, then things get
wierd

It fails in Access runtime!!! (throws unhandled exception, then exit)

[snip]

And that error is?

 

[Larry Daugherty]

Hi Ed,

Sorry about that but you already know the bad news. You probably
already have some third party tool to comment your code. Once I
really understood the need for 100% error handling I settled on Code
Stuffer from Duane Hookom. I know that there are others. Something
like that can sure save you a lot of keyboarding.

Note, I said "understood the need". I have lots of stuff that isn't
intended to ever get into MDE format nor to leave the house without
remediation.

HTH