Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 97 & Win2000 DDE Server Error

Posted on 2002-07-23
6
Medium Priority
?
487 Views
Last Modified: 2009-07-29
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!!
0
Comment
Question by:FinanciallyFree
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 9

Expert Comment

by:perove
ID: 7172265
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
 

Author Comment

by:FinanciallyFree
ID: 7173347
perove:
I will try this on Wednesday 7/24 and will let you know how it goes. Thank you!!
0
 

Author Comment

by:FinanciallyFree
ID: 7229125
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:FinanciallyFree
ID: 7236731
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
 
LVL 54

Expert Comment

by:nico5038
ID: 7281579

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
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 7315448
This question will be placed in PAQ and points refunded.

Best regards,
ComTech
Community Support
Administrator @ EE
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question