Re: URGENT: Access Crash after System Update!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Klatuu,

The code is pretty simple:

[code]
Private Sub cmdFormulationZoom_Click()
On Error GoTo Err_cmdFormulationZoom_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_material_formulation_editor"

stLinkCriteria = "id_material_product =" & Me![id_material]
DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria, , acDialog

Exit_cmdFormulationZoom_Click:
Exit Sub

Err_cmdFormulationZoom_Click:
MsgBox Err.description
Resume Exit_cmdFormulationZoom_Click

End Sub

[/code]

I'm pretty sure that the problem is not there, since the following
trick seems to work: I have seen hints that have to do with subforms
and when they should get displayed, and I've been messing about with
that. Mainly, I changed a subform so that it does not load until a tab
gets selected: Then I set the SourceObject of the subform from the
TabCtl "OnChange" event. Before this, there was no code in any of the
target form events. Does this ring a bell for anyone?

Thanks again!

Klatuu wrote:
Post the code where the openform is failing, please

"webmaster@xxxxxxxx" wrote:

Hi Klatuu,

Thanks for the quick response! Yes, this is happening on multiple
machines.

This is happening when one form opens another form. frmA opens frmB
with a "where" condition as part of the "DoCmd.OpenForm" method.

This is really perplexing. The code works if I do a "system restore" to
a previous checkpoint. I have been tweaking code to try to work around
the problem with no success.

I have discovered, however, that stepping through the VB code, THIS
PROBLEM DOES *NOT* HAPPEN. Arghh!

Thanks for the help!


Klatuu wrote:
I have not experienced this problem; however, based on the error log report
you posted (good work), it appears to be a problems with msjtes40.dll. It
should be in C:\Windows\system32. It is part of Jet. You appear to have the
correct version.
I would make sure the file it is there and is not corrupt. Do you have
another machine you can copy it from?
When is the error happening? Is is happening on more than one machine?

"webmaster@xxxxxxxx" wrote:

Hello!

Windows XP SP2 Latest Patches, IE7 blocked
Access 2003 Latest, all patched

I have an application that has _started_ _to_ _crash_ _ACCESS_ after
the latest software updates!

Here is the message:

--
Microsoft Office Access has encountered a problem and needs to close.
We are sorry for the inconvenience.
--

When I select "What does this error report contain?" I get the
following:

Error signature
AppName: msaccess.exe
AppVer: 11.0.6566.0
AppStamp: 42cdb33e

ModName: msjtes40.dll
ModVer: 4.0.8618.0
ModStamp: 403430ac

fDebug: 0
Offset: 00008f7a

--

Has any one else seen this problem?

THIS WORKS WHEN I RESTORE MY SYSTEM!

Thanks in advance for any help anyone can share on this problem!





.

Relevant Pages

  • Opening a Form
    ... Private Sub Command235_Click ... Dim stDocName As String ... Dim stLinkCriteria As String ...
    (microsoft.public.access.forms)
  • Error using Like* operator
    ... Private Sub Command3_Click ... Dim stDocName As String ... Dim stLinkCriteria As String ...
    (microsoft.public.access.formscoding)
  • Changing the title on a form with VB
    ... Dim stDocName As String ... Dim stLinkCriteria As String ... Private Sub Button2_Click ...
    (microsoft.public.access.formscoding)
  • Re: Canceling a double-click event
    ... Private Sub JudgeBarRollNo_DblClick ... Dim stDocName As String ... Dim stLinkCriteria As String ...
    (microsoft.public.access.formscoding)
  • Referring to a sub form on a tabbed form
    ... Private Sub lstResult_DblClick ... Dim stDocName As String ... Dim stLinkCriteria As String ...
    (microsoft.public.access.formscoding)