Access 2002: WinXP SP2 Problem

[John Hardin]

We have been running a particular Access application since version 97 -
upgrading the database with each new version of Access. Application ran fine
with Windows XP SP1, but began failing when we upgraded to SP2.

The switchboard form opens fine, but when we attempt to open another form
from the switchboard, we get "Microsoft Access has encountered a problem and
needs to close"

AppName: msaccess.exe AppVer: 10.0.2627.1 ModName: msjtes40.dll
ModVer: 4.0.8618.0 Offset: 0000413c

The form actually does display with data before the error appears. The
funny thing is that when I step through the code that displays the form in
debug mode, I don't get the error. However, as soon as I remove my
breakpoints and let the code run at full speed, I do get the error.

I have no trouble opening individual tables, running queries, or creating
reports. This application uses linked tables - some residing in another .mdb
and others in SQL Server. I was able to successfully refresh all table links.

Removing Windows XP SP2 from the machine solves this problem - but this is
NOT a viable long-term solution.

Has anyone else experienced a similar problem under SP2? Is there a
long-term fix? Thanks.

 

[John Hardin]

Addendum:

I created a new blank database on my machine running Windows XP SP2 and then
imported all of the objects from my broken database. For some unknown
reason, this resolved the problem I was experiencing.

If anyone has an explanation for this, I'd love to hear it.

 

[hinerman]

Addendum:

I created a new blank database on my machine running Windows XP SP2 and then
imported all of the objects from my broken database. For some unknown
reason, this resolved the problem I was experiencing.

If anyone has an explanation for this, I'd love to hear it.

 

[hinerman]

yes

 

[hinerman]

I had the same problem and had to do the same thing to fix mine. The
only difference I noted is that the old Maybe that's the difference?

 

[hinerman]

I had the same problem and had to do the same thing to fix mine. The
only difference I noted is that the old one used a UNC path, while the
new one uses a file path. Maybe that's the difference?