Queries crashing A2003

[Jeemo]

I've been tearing my hair out on this one. This effin' database keeps crashing on me while I'm doing query-related operations.

System info:
Access 2003 SP2 with all the latest updates on an XP Pro machine.

DB info:
The database file in question is merely several queries based upon a single, linked Excel file of about 17,000 records that resides in the same directory as the Access file, both of which are stored locally on my machine.

Problem:
It started when I was simply right-clicking on a field in the query's design view and selecting "build." It would hesitate for a moment, then it would crash and offer the option to "Repair and re-open" the database and send an error report or not. I tried opening the database file in Access 2K on my home machine and the problem would not occur in that environment.

I'm now trying to run a very simple Union query and I'm experiencing the same problem. Here's the SQL statement:

SELECT [Analysis - Unique Checks].Date, [Analysis - Unique Checks].Time
FROM [Analysis - Unique Checks]
UNION SELECT [Average User Count of Duplicates].Date, [Average User Count of Duplicates].Time
FROM [Average User Count of Duplicates];

Here's the meat and potatoes from the error report:

AppName: msaccess.exe      AppVer: 11.0.6566.0     AppStamp:42cdb33e
ModName: msjtes40.dll      ModVer: 4.0.8618.0      ModStamp:403430ac
fDebug: 0       Offset: 000092d0

Attempted solutions: (none of these have had any effect)
Did a repair of Office/Access
Uninstalled and re-installed Access
Uninstalled and re-installed Office
Performed a compact/repair on the database file.

Thanks in advance for any help on this one.

[Jeemo]

Mmmmmyello'?

[Jeemo]

Everyone, please. Does anyone have any suggestions? I've posted this twice already, with zero response. Somebody please help.

[Jeemo]

Still stuck here. Does anyone have any suggestions? I'll even be content with "maybe you should stop trying to get help here for this problem." Please. Something.

[helter7skelter]

Jeemo

Did yout get any results on this problem?

I have been getting the same problem (msjtes40.dll, 403430ac) for a few months, and it is driving me mad.

I get the error on various forms with subforms, when data changes are being saved. ie, by moving to a new record or hitting shift-enter to save the data. It doesnt happen all the time thankfully, but still a few times every day.

I have searched all over, and cannot find a definitive answer or suggestion.

Cheers

[flyingcessnas]

I'm not sure if this is an open issue for you or not, but I recently had it come up and yours was the only post I could find about it.

We solved the issue by doing the following:

1.) Download and Install SP3 for Office 2003
2.) Click Tools >> Database Utilities >> Convert Database >> Choose a Prior Version

That should fix the issue (as far as we have seen so far). My guess is that it comes from coding in VB and then upgrading to Access 2003..but that is only a guess.

Good luck :-)

[missinglinq]

And good luck to you, if you've installed SP3! You might want to look at Allen Browne's Bugs introduced by SP3 for Office 2003

Welcome to TheScripts!

Linq ;0)>