?
Solved

Access 97 runtime on computer with Access 2007 - Install fails with "no license error"

Posted on 2009-04-25
22
Medium Priority
?
1,573 Views
Last Modified: 2012-06-17
I am having to distribute a program written years ago in MS Access 97.  The program's installer puts the Access 97 runtime on the customers computer.  If the install fails with the well known font error, I have them do the age old font rename fix and try again.  

Next if  they get the dreaded "Microsoft Access can't start because there is no License for it on this machine" error.  I ask the if they have MS Office/Access 2007.  The answer has been yes both times this error has occured.

All the solutions I have read talk about reinstalling MS Access 97 using MS Office 97 setup file...
        http://support.microsoft.com/default.aspx?scid=kb;en-us;141373&product=acc97       
Since this is just the runtime there is no MS Office 97 to reinstall.

I am stumped on how to get past this problem.  Any help greatly appreciated.

Thanks,
David
0
Comment
Question by:rdskill
  • 11
  • 10
22 Comments
 
LVL 28

Expert Comment

by:burrcm
ID: 24234536
So the desired result is an access mdb or mde? Once it is installed, you can copy the database off and distribute it. It will open with whatever version is installed. If Access is not installed, you can use the original installer.

Chris B
0
 

Author Comment

by:rdskill
ID: 24234557
Hi Chris,
Thanks for the reply!  The desired result once installed is a mde.  I am not doing the install.  We have customers doing their own installs.

Each person having the "no License" issue already had Office 2007 installed.   They were installing this program which loads the Access 97 runtime.   After doing the "rename the font" fix and trying to complete the install, they get the  "Microsoft Access can't start because there is no License for it on this machine" error.

There is no way to seperate the database embedded in this program.  We don't have access to the source.  The programmer refused to give it to the company when he was terminated.  So we can look at some of it but are unable to access or modify any of the macros or modules.

David
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24235022
You can't alter the macros or modules in any mde, that is the idea, but it doesn't really "install" it will just copy the mde to the hard drive. Once you have done this on a machine which doesn't have 2007, you should be able to take a copy of the mde file and use it elsewhere. The <<Microsoft Access can't start because there is no License for it on this machine>> error relates directly to the hatten.ttf font being on the machine. Are you sure you are renaming this (to Hatten.old) prior to installing?

Chris B
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 85
ID: 24235586
Another suggestion would be to allow your users to run the 97 db in 2007. Generally 2007 will run older databases.
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24235637
I thought I implied that. Take the mde installed by the installer and copy it to machines with 2007 (or anything else). It will then run without the 97 runtime.

Chris B
0
 

Author Comment

by:rdskill
ID: 24236102
Thanks burrcm & Lsm.

I was talking about the original source files in the mdb for application.  We'd love to make some changes, but are stuck with what we have.

In both cases the install froze up while installing fonts.  I sent the the rename the font fix and they applied it.  Reran the install and then the "no license" error happened.

Ok... so your both thinking 2007 will run the mde.  I do know I can't open the mdb using Access 2007.  But I will have the customer try without the runtime.   I'll have them remove the 97 runtime, then reboot, before copying the mde in.  This is a locked (?) mde.  Must have a named mdw file as well.

hmmm... maybe I'll test it on Monday first.  I'll let you know how it turns out.

Thanks!
0
 

Author Comment

by:rdskill
ID: 24273467
Sorry for the delay.  Crazy week at work.

I tried running the mde under ms access 2007 but was not successfull.  

Here is the original shortcut target text:  "C:\Program Files\Access 97 Runtime\msaccess.exe" /runtime  /profile "BICCS"  /wrkgrp "C:\BICCS\client.mdw" "C:\BICCS\BW-Digitrace3.mde"

I renamed the Access 97 Runtime folder and pointed it to the ms access 2007 program.  Here is the new target text: "C:\Program Files\Microsoft Office\ART\Office12\MSACCESS.EXE" /runtime  /profile "BICCS"  /wrkgrp "C:\BICCS\client.mdw" "C:\BICCS\BW-Digitrace3.mde"

When I ran it via the shortcut I got the following error from MS Access 2007:  "The current user account doesn't have permission to convert or enable this database"

Now I am not sure how I can proceed.  Any suggestions would be appreciated.  I can even send you the deploy file, but i would suggest loading it to a VM.

Thanks,
David
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24279560
Does C:\BICCS\client.mdw exist on the test machine? If it does, just navigate to the mde and double click. What happens then? If the mdw is not in place, copy it off a machine which is functioning correctly.

Chris B
0
 

Author Comment

by:rdskill
ID: 24280283

Thanks Chris.

I already have the mdw in the same directory. I created a vm and did an install. This is what was put into the C:\biccs directory that was created by the install:
AA.mde
BB.mdb
CC.mdw (client.mdw)
DD.mdb

It also installed msaccess.exe in the C:\Program Files\Access 97 Runtime directory.

This is the directory I now renamed so msaccess is not found in it.
When I double click on the mde it finds msaccess.exe for 2007 and launches it.  It then gives me the error I mentioned in my previous message.. "The current user account doesn't have permission to convert or enable this database."
The programmer had done this was let go and hasn't given the company the information that will allow us to unlock this database.
0
 
LVL 28

Accepted Solution

by:
burrcm earned 2000 total points
ID: 24283398
Error alert. Mine that is. This from Microsoft - Converting a database
By default, Access 97 or earlier format databases are converted into Access 2002-2003 format. If a database is converted to Access 2002 or Access 2003, the database can only be opened by Access 2002 or Access 2003. To convert an Access 97 or earlier database to Office Access 2007 ACCDB file format, you must first convert it to Access 2002, Access 2003, or Access 2000. You can then convert the database to Office Access 2007.
MDE file limitations
MDE files are MDB files that have VBA source code compiled into computer code and VBA source code removed. Office Access 2007 cannot convert or enable an MDE file. To upgrade an MDE file, you must find the original MDB file and convert that file.

Or to put it another way, it cannot be done with 2007. Sorry.

Chris B
0
 

Author Comment

by:rdskill
ID: 24284821
good find!  

So now I just need to figure out how to get it past that "no License" issue that is still happening.  The user has already done the infamous "rename the font" fix.  

Perhaps he just needs to uninstall the program and try reinstalling it.   I am not sure if he did the uninstall part after doing the font fix.  Should have him remove msaccess 97 folder too.  Interesting thing... after I installed this program and it added the msaccess 97 folder... I checked for msaccess 97 in the Add/Remove Programs ... and its not listed in there!   I was surprised at that.

Any suggestions?   Its kind of a mystery.  lol

Cheers,
David

0
 
LVL 28

Expert Comment

by:burrcm
ID: 24284929
Happy to experiment if you zip it and post, either here or to one of the sharing sites like Rapidshare. You may have suggested the best solution yourself though, set it up in a VM and deploy that. MS Virtual PC and 98 perhaps? How complex is this db? Another solution would be to rewrite it.

Chris B
0
 

Author Comment

by:rdskill
ID: 24299077

Hi Chirs,

I have uploaded it to Rapidshare.  Do you have a email address I can send the link to or would you prefer I post the link here?

The VM wouldn't work because it would be a bit much for our customers to deal with.  They really don't want to be bothered with the extra steps.   As for re-writing....  if we had the source could I would do so, but we are going to take a different approach.  Keeping this program is just  a stop gap solution for the next few months.

David
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24299186
Hi

Ideally post it here, but if you want to restrict access, email on my profile, just click burrcm above. If anyone else wants to have a look, they can provide an email also.

Chris B
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24313738
Moving on... The initial solution is very simple, remove Office 2007 install the BICCS package and all works swimmingly. Put O2007 back and it fails once more. Will now do some registry snapshot / compares to see where we are getting knocked off. Back in a day or two......

Chris B

p.s. Two teens 14 and 16. I may survive.
0
 

Author Comment

by:rdskill
ID: 24346183
Puts his money on the teenagers.
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24383635
Still working on it. Had a couple of unexpected developments.

Chris B
0
 

Author Comment

by:rdskill
ID: 24383654

Cool !   Thanks Chris.
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24430699
Some developments. I have it running alongside Office 2007 on Vista. Before I installed it I renamed the hatten font, so I didn't get the no license error, just can't initialize the registry. Resolved this by turning off UAC as it was a permissions error, not a license problem. Give this a try and see how you go. User Account Control - Control Panel - User Accounts - Turn User Account Control On or Off.

Chris B
0
 

Author Comment

by:rdskill
ID: 24430821
Thanks Chris.  I will have them give this a try.  I can't remember offhand if they were running XP or Vista.  I will check it out when I go into work today.
0
 

Author Closing Comment

by:rdskill
ID: 31574578
Thanks Chris for you patience and perseverance!
0
 
LVL 28

Expert Comment

by:burrcm
ID: 24646883
One final word, once I got it running, and it made it's needed adjustments to the registry, I was able to turn UAC back on and it continued to run. Thanks for the points.

Chris B
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

864 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