Solved

Get access 97 Runtime to work in Win 7

Posted on 2013-02-07
17
12,063 Views
Last Modified: 2013-04-15
Hello,

nothing like trying to make the old work with the new to get the blood flowing in the veins, eh?!
Who's with me?!
ok... so I NEED to get M$ access 97 runtime to work in windows 7. Has anyone been able to accomplish this? It can not be full versions of access because of security risks. I know and have successfully made the regular version of access 97 work on a win 7 machine (by following steps found on this site changing a few font files etc). However, I have had zero luck getting JUST the runtime to work.

Unfortunately,  there is no option to upgrade the databases to new versions of access atm...

Put your thinking caps on fellow IT sufferers!
Thanks in advance... lots of real Java to the winner!
0
Comment
Question by:itsthunt
[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
  • 6
  • 4
  • +1
17 Comments
 
LVL 75
ID: 38865932
Note that Microsoft does *not* support A97 running in Win7.  So ... even ... if you get it to work, all bets are off.

Just sayin ...

mx
0
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 38865941
My suggestion would be to run a virtual machine with an older operating system such as xp or 2000, and run the Access 97 runtime in the VM.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 38867345
Yes, save your trouble and download and install the free XP Mode virtual machine:

http://windows.microsoft.com/en-us/windows7/products/features/windows-xp-mode

/gustav
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 38867469
Thanks, Gustav. Also available for free is the VMWare Player. Simply install it and then you can create any number of virtual machines; all you need is the OS installation disc or an ISO file. This is also a great way to experiment with free preview editions, Linux, test environments and so much more. You can even virtualize an existing computer using their free VMWare VCenter Converter Standalone. Enjoy.
https://my.vmware.com/web/vmware/downloads
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 38867485
Yes, we use VMware Server a lot. Runs rock stable.

The trick with XP Mode is that the license for Windows XP running in this is free and included.

/gustav
0
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 38867646
The limitation with the XP Mode is, as quoted from the above link, "Designed primarily with small- and medium-sized businesses in mind, Windows XP Mode comes as a separate download and works only with Windows 7 Professional, Ultimate, and Enterprise." It also enforces a licensing verification routine that will not allow it to install on a Windows 7 machine that has not been activated, which can hamper certain test environment protocols where you would want to make sure everything is working perfectly before "burning" the activation with your license keycode. Also the VMWare player allows a multitude of operating systems - with the drawback that you would need to have the license key code for the OS as if it were a standalone computer. Pros and cons for each, but still a valid path to resolve this kind of problem.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 38867694
That's true.
However, we have only clients running fully licensed software so it has never been an issue.

A worse limitation is that it is Win7 only, no Windows 8.

/gustav
0
 

Author Comment

by:itsthunt
ID: 38867887
Thank you for the responses!
*Yes* I know it would not be supported;
*VMWare* although an effective solution for some situations (which I have used), I dont believe would be efficient or effective in this case (I need to roll it out to 140 workstations). and the amount of IT support after would probably cause my brain to pop...
*xp mode* unfortunately, the install just fails out with "wrong o/s" error.

Keep em coming... Thanks!!!
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 38867920
> Make sure you're running Windows 7 Professional, Enterprise, or Ultimate.

> I need to roll it out to 140 workstations ...

Those editions are typical for corporate use. Do you really run one of the Home editions??

/gustav
0
 

Author Comment

by:itsthunt
ID: 38868066
no, we are on Win7 professional...
0
 

Author Comment

by:itsthunt
ID: 38868071
so just to clarify, I am looking to have M$ Access 97 RUNTIME to work in windows 7 Professional...
Cheers!
0
 
LVL 13

Expert Comment

by:Norm Dickinson
ID: 38868081
Perhaps a single VM located on the server using Remote Desktop Services (terminal server style) would allow the rollout to be more efficient. Also available, for a fee, are cloud services such as RackSpace.com where you could roll out virtual workstations as needed and connect to them over the web.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 38868191
> we are on Win7 professional...

Then the XP Mode _will_ install as seen at the opening page of the link I posted - _if_ your Windows is updated beyond a certain level (which I cannot recall) and some hardware requirements are met (which most newer machines do):

http://windows.microsoft.com/en-us/windows7/install-and-use-windows-xp-mode-in-windows-7

Another feature is the "One click launch of Windows XP Mode applications" which - quite easily - will let you create a shortcut on the Win7 desktop that opens the XP and launces your app framed in a window that looks like any other Windows app - in other words: the XP desktop etc. is not visible for the user.

/gustav
0
 

Author Comment

by:itsthunt
ID: 38869352
Ok here is the latest...

I have XP mode working and one of the access programs works (It doesnt have any security on it). But the access databases that have login security on them will not open...

Altho the virtual machine is not ideal, If there is no other options to simply run the access 97 Runtime, then I guess it will have to be...


Also, I did find this download, http://donnedwards.openaccess.co.za/2007/03/finally-access97-runtime-installs.html

which seemed to work as well... but same login error issue....
0
 

Accepted Solution

by:
itsthunt earned 0 total points
ID: 39065848
Hi, Here is the final update...

I was able to ger Access97 runtime to work on both Win7 and Win8 by using the download:
http://donnedwards.openaccess.co.za/2007/03/finally-access97-runtime-installs.html

I added the ODBC database connections using the 32 bit version located: C:\Windows\SysWOW64\odbcad32.exe

I then pointed the shortcut to "start in: C:\dev\office" (where the access97 runtime is)

Then edited the shortcut to point to the correct mde:
Entire shortcut {--
 C:\dev\office\msaccess.exe "X:\Common\apps\util.mde" /wrkgrp "P:\Common\apps\mdws\APPS.MDW" /user --}
(you can edit the "user" to put the actual user name in if want).

Huge shout out to Donn Edwards who made the access97 runtime program install.

Thank you to those who suggested other fixes.

Hopefully this helps some other poor sap like me who just needed to make an old program work on new stuff!

Good Luck!
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39065993
Thanks for the round up!

/gustav
0
 

Author Closing Comment

by:itsthunt
ID: 39079774
Updated solution That I came to in order to make it work.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

729 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