Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / February 2006

Tip: Looking for answers? Try searching our database.

MDB works MDE Fails

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ed Warren - 16 Feb 2006 11:08 GMT
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 - 16 Feb 2006 12:36 GMT
> 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!
[quoted text clipped - 12 lines]
>
> It fails in Access runtime!!!  (throws unhandled exception, then exit)
[snip]

And that error is?

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

Larry Daugherty - 18 Feb 2006 23:17 GMT
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
Signature

-Larry-
--

> 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!
[quoted text clipped - 28 lines]
>
> Ed Warren.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.