Questions? Search our site or call us at 1-800-722-6004

Lost Data when Running Multiple Instances of WinWedge in Microsoft Access

When you use multiple instances of WinWedge to bring data from several devices into an MS Access database, you may lose a data record being sent from one device if Access is still processing a record from another device.

The following procedure should correct this problem.

  1. Launch Access and open the database.
  2. Open the Tools menu, and select Options.
  3. Select the Advanced tab in the Options dialog box.
  4. In the DDE Operations section, make sure that:
    1. the Ignore DDE Requests option is NOT checked; and
    2. the Enable DDE Refresh option IS checked.
  5. Set the OLE/DDE Timeout (sec) value to 30.
  6. Set the Number of Update Retries value to 2.
  7. Click the OK button.

These settings should allow you to reliably process all DDE commands from multiple instances of WinWedge, even if multiple data records arrive simultaneously.

Another thing to check is that you are not doing too much in any of the macros that are forced to run by WinWedge. In other words, in your Access functions that are doing the DDERequests back to the WinWedge, you should grab the data from WinWedge and get out as quickly as possible. If you need to perform lengthy operations in these functions, then you may need to throw a few DoEvents statements into the code to yield processor time to other routines while you are in the middle of an intensive operation.


Categories: Troubleshooting, Microsoft Access

Last Updated: 2011.07.05

Need more help?

Don't hesitate to call or email us with your questions

Our office is open 9AM - 5PM Monday Through Friday (E.S.T.)

Technical Support: 215-496-0202

Toll-Free: 1 (800) 722-6004
Skype: taltech1 (Voice only)
Email: support@TALtech.com