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

Microsoft, Office 97 on Windows XP, Office 97, Installation error

We have recently purchased a new XP pc and installed office 2007 pro, We need to run Access 97 on this box, so we uninstalled 2007 and proceeded to install office 97 pro. I get the following error at the end of the installation. "an error has occured at changing workgroup database" After a reboot I get the following error when attempting to run Access 97 "Microsoft access can not start because there is no license for it on this machine" I am logged in as a local administrator on the machine. Please Help
0
mikcanavan
Asked:
mikcanavan
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>We need to run Access 97 on this box, so we uninstalled 2007
If you wanted to have both, you could have installed Access 97 without uninstalling Access 2007.

Also, Access licensing is version-specific, so purchasing a 2007 license does not entitle you to an Access 97 license.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
{Wild guess}

Go to C:\Program Files\Microsoft Office\Office\msaccess.exe, then double-click on the 'MS Access Worgroup Administrator'.exe that installed with Access '97.
In the form that pops up, eyeball what's in the Workgroup section.  Likely it's the Access 2003 .mdw location.
Change it to %SYS%\system.mdw (on my pc, %SYS% is c:\winnt\system32), save, close, then try to open Access again.
0
 
mikcanavanAuthor Commented:
We do not want to run 2007 and we have a full version of 97 that we have installed
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
{correction, too early in the morning}

Go to C:\Program Files\Microsoft Office, then double-click on the 'MS Access Worgroup Administrator'.exe that installed with Access '97.
In the form that pops up, eyeball what's in the Workgroup section.  Likely it's the Access 2003 .mdw location.
Change it to %SYS%\system.mdw (on my pc, %SYS% is c:\winnt\system32), save, close, then try to open Access again.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Another thought; if you have any shortcuts that lead to Access apps, you'll want to do a right-click:Properties and view what's in the Target textbox.

If the first part of the Target is the location of Access 2007, i.e. "C:\Program Files\Microsoft Office\Office12\msaccess.exe"
... then change it to the Access 97 location "c:\Program Files Microsoft Office\office\msaccess.exe"

Good luck.
-Jim
0
 
mikcanavanAuthor Commented:
workgroup section is C:\windows\system32\system.mdw

I get the option to create or join.

If I click create it asks me for an ID, after which I get the same error i.e. "an err has occured at changing....."

If I click join it allows me to edit a path i.e. "C:\windows\system32\system.mdw"

After I click ok on the above I get the following error, "can not find file C:\windows\system32\system.mdw

0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>After I click ok on the above I get the following error, "can not find file C:\windows\system32\system.mdw
Strange.  Just for kicks and giggles, let's see if we can avoid the .mdw altogether.

Create a shortcut that has in its Target textbox just the Access exe location, and your app location, with no reference to mdw
"c:\Program Files\Microsoft Office\Office\msaccess.exe" "c:\Program Files\Microsoft Office\Samples\Northwind.mdb"

Save, close run it, let's see what happens.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Perhaps this KB article will help:
http://support.microsoft.com/kb/241141
0
 
mikcanavanAuthor Commented:
Hi Jimhorn

Thanks for your input on this - but the problem seems to have been fixed using :

http://support.microsoft.com/kb/191224/

I simply needed to rename a font until Access had started once.

Many thanks anyway.
0
 
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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