• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2739
  • Last Modified:

Access 97 Software Not Running On Windows 7 Machines

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 (http://support.microsoft.com/default.aspx?scid=kb;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:

http://support.microsoft.com/default.aspx?scid=kb;en-us;246169
http://support.microsoft.com/default.aspx?scid=kb;en-us;194374
http://support.microsoft.com/kb/194374
http://www.tek-tips.com/faqs.cfm?fid=2959

Thanks,
Greg
0
Greg_L_WER
Asked:
Greg_L_WER
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
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
0
 
macarrillo1Commented:
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.
0
 
Greg_L_WERAuthor Commented:
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.

Thanks,
Greg
0
 
Greg_L_WERAuthor Commented:
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 :)

Thanks,
Greg
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now