Access 97 & Win2000 DDE Server Error
Posted on 2002-07-23
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!!