Access 97 & Win2000 DDE Server Error

Has anyone got any insight here?

My Access 97 program has been working successfully for YEARS under Win95, Win98, and WinNT.

Recently, two PCs were upgraded to Win2000. Suddenly I receive an error like this:


DDE Server Window MSACCESS.EXE Application Error
The instruction at 0x77fcb2b9 referenced memory at 0x8328d40f. The memory could not be "written". Click on OK to terminate the program.


The first address reference can change, but for the most part the "memory at" reference is the same.

This error only happens on the Win2000 PCs. The same code works just fine on WinNT and Win98.

This error happens in only one place in the entire program. I have a list where the user selects one or more items and the query pulls up a report showing the records that match. This is only one out of probably 8+ places in my program that do exactly the same thing. This is only happening in this one. There are more complex queries, but they don't have any errors. The code is identical for all areas with only field names changing.

What's up? THANKS!!
FinanciallyFreeAsked:
Who is Participating?
 
ComTechCommented:
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
Administrator @ EE
0
 
peroveCommented:
My best advise is to recompile the MDB on WIN2000 machine.

howto:

Open you database with the /DECOMPILE swich.
ex:
c:\myapps\msaccess.exe c:\mymdbs\mymdb.mdb /DECOMPILE

do a compact
then open a module and do a compileandsaveAllmodules

MS also has a artichle about GPF's in access

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q148424&

0
 
FinanciallyFreeAuthor Commented:
perove:
I will try this on Wednesday 7/24 and will let you know how it goes. Thank you!!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
FinanciallyFreeAuthor Commented:
perove,
My deepest apologies for the delay. Had a family emergency. I'm back now.

The recompile did not affect the error message.

Another revelation has come... this only happens on LAPTOPS with Windows 2000. Desktop Windows 2000 is not a problem.

Thanks so much for your help
0
 
FinanciallyFreeAuthor Commented:
I've done the /decompile with no success.

I was told to create a new database and import all the objects from the current one. Did it with no success. Still hoping for help...

Thanks!
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

BTW did you solve the problem?
If not I would check the Tools/References (open first some VBA code) of the .mdb, looks like there are some MISSING libraries.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.