Random failure of Access 97 Application on XP

I have a large application in A97 that has recently started to fail randomly on startup.

The problem is always on XP (W2K is never a problem). It can work for weeks or months and then bingo - it fails on startup with a message like "unknown function CurrentUser" which is coming from an add-in of ours that is loaded after the main application.

The only solution I currently have is to go back to an old version which does not seem to suffer from this problem (though there are no significant differences between the versions)

The application consists of a master application and several add-ins - all compiled into .mde

I recently installed three identical Dell PCs at a new client and loaded the application. Worked fine for a few days and then two of them failed. I re-installed the application and one worked for a short while the others still failed.

I took one of the failing machines back to my office, connected it to my network and loaded the client's data onto my server (both mine and client's servers running W2K server) and it never ever failed - tried it dozens of times! Maybe I have a nicer office wallpaper! :(

I obviously need to identify what it is that may be causing this problem. I wonder whether changing references to a newer version may help.

Currently I have selected:

Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library

plus my own add-ins.

I see that on the list is shown

Microsoft DAO 3.6 Object Library

Would trying this in place of 3.51 be advisable? [*] I'm not sure where this version came from. Is it likely that all my clients would have this version installed? Some only have Office 97 SR2 installed.

[*] I have a vague feeling that I have tried 3.6 some time in the past but had problems - cannot be certain.

Any suggestions on how to solve this would be most appreciated.

Thanks.
--
Les Desser
(The Reply-to address IS valid)
.

Relevant Pages

  • Re: Random failure of Access 97 Application on XP
    ... Did you download and install Office 97 Service Release 2b? ... The application consists of a master application and several add-ins - ... client's servers running W2K server) and it never ever failed - tried it ... Microsoft DAO 3.51 Object Library ...
    (comp.databases.ms-access)
  • Re: Office 2003 word hangs on startup
    ... You should be able to easily prove it is the add-ins delaying the start by temporarily moving everything out of Startup and experience the difference. ... "Suzanne S. Barnhill" wrote in message ... >> Word MVP FAQ site: http://word.mvps.org ...
    (microsoft.public.word.application.errors)
  • Re: macros in Word are disabled
    ... You would *not* be getting these messages at startup if you didn't have ... add-ins loading. ... > templates and add-ins" but that continues to send the error. ... >> in the User Templates, Workgroup Templates, or Word Startup folder. ...
    (microsoft.public.word.application.errors)
  • Re: Starting apache at boot with SSL.
    ... > that so that the previous bin sh script gets invoked and the server ... > will startup at that point. ... >> The problem with this setup is that if the server reboots in the middle ... Remove the encryption from the RSA private key (while preserving ...
    (freebsd-questions)
  • Re: Restricting Which Installed Applications Start For Terminal us
    ... "Although I'm a bit puzzled as to why you'd want to run FTP ... When I removed the check from the Startup entries in MSCONFIG the ... Is the simplest solution to just place a shortcut in the admin startup ... user on the Terminal Server? ...
    (microsoft.public.windows.terminal_services)