Access 97 Software Not Running On Windows 7 Machines

Posted on 2012-08-16
Last Modified: 2012-08-20
I'm running a program built in Access 97 that has worked fine in Windows XP and Windows 7 until today when it looks like some Windows updates have caused an issue.  The problem I'm encountering is similar to (;en-us;246169 - MDE Database Must Be Recompiled Under Current Service Release) where it looks like the library files used in the software have been replaced by the Windows updates.  I did have 2 XP machines this morning that weren't working though once I replaced the different library files with ones that I had saved months ago these 2 PC's started running properly again.  Unfortunately this same fix hasn't worked on the Windows 7 Machines.  The files that my program references are:

-- VBA332.DLL -  In "C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\"
-- MSACC8.OLB - In "C:\Program Files\Microsoft Office\Office\"
-- MSCOMCTL.OCX - In "C:\WINDOWS\system32\" also in my progam directory "D:\Books\Office\"
-- dao350.dll - In "C:\Program Files\Common Files\Microsoft Shared\DAO\"

All my Windows machines are running the 64 bit version of Windows so I also copied/created the Program Files (x86) versions of any file located in the Program Files folder in XP.

The error message that comes up when running the program is "Function Isn't Available in Expressions in Query Expression..."

I've read and tried the suggestions on the following with no luck:;en-us;246169;en-us;194374

Question by:Greg_L_WER
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    Not sure, but some thoughts:
    1. What version of Win 7 please?
    Certain codes require modifications to run in 64 bit operating systems.

    2. Window and Office share a great many files, ..and Windows 7 does not offer explicit or implicit support for an Office version that is over 10 years old. (Access/Office 97)

    Remember MS dropped support for Office 97 in 2002.

    This is not to say that you "Can't" run Acc 97 under Win7...
    ...only that if you indeed can't,  MS will not offer any support.

    Just curious, is there a reason why you cannot at least upgrade to 2007?

    Let's  see if another expert can get you going directly

    Jeffrey Coachman
    LVL 9

    Accepted Solution

    You stated that this problem occurred once Windows ran an update. Is this to imply that windows is fully up to date with all its updates?

    I would suggest:
    1. Ensure that windows and Office are as up to date as you can get them. Test.
    2. If Access Opens then run compact and repair on your database. Test
    3. If Access Opens then create a blank database and import everything from the problem database.
    4. Backup your database and re-install Access.

    Author Comment

    Jeffrey - Thanks for the info...

    I'm using Windows 7 Professional Service Pack 1 with all the latest critical updates.  The program had run fine on the Windows 7 and XP machines for years... last Wednesday one machine wasn't working properly and the enxt morning 6 others had stopped working as well.  4 Windows 7 machines and 2 XP machines.  I was able to get the XP machines running again by coping a previously saved version of the above mentioned files into the required directories.

    As for upgrading to a newer version of Access.  Years ago I attempted to do this to Access 2000 and it was so messy that I bailed out before I got too far.  Have you had any success upgrading a database in the past?

    Macarrillo1 - Thanks for the info...

    Windows is fully up to date with the critical updates.  I had run all the Office 97 updates that I could find.  I'll try your other suggestions and post an update once completed.


    Author Comment

    Macarrillo1, Thanks SO much for the solution...  it worked great!  I had considered it early in my trouble shooting but discounted it as it was working fine on my XP machines... I don't make that mistake again :)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now