Office 2000/ODE97

Anybody else have this problem? Or can help me to help myself.

I have a program developed in Access97. It includes several DLL's, some EXE's and a XLA function libray.
(This has nothing to do with the problem)

The program has been sold to approx 500 customers around scandinavia so what I'm looking for is a general solution not a solution on how to fix a certian installation.

So to the problem:
When I try to install the Access runtime files (created with ODE 97) the msaccess.exe (among others) dont get installed if the customers machine have a Office 2000 pro installed before.

This is the problem, but it only happen sometimes, on other installation it goes "normal" and I can have two installations of msaccess.exe on the same machine and on the same time.

Anybody have any experience with this. I'm sure I can solve this with un-installing office2000 then install access runtime and then install office 2000 (and answer YES when asked to keep older versions) but we're talking 500 customers with maby 5 clients each so using this solution I will not get the "software developer of the year price, in the class for easy installations" (not that I would get it anyway ...)
 
:)

I have been doin' som research yesterday, and have the following theory:

If you have a brand new machine that are installed with office2000, the installation of Access97 Runtime goes fine. But of you have a upgraded office2000 you will not get Access97 Runtime installed.

Any exp. or comments to share here my friends??
There must be a "easy" way that Access2000 and Access97 can live "in perfect harmony" or...

The last month or so I have been working with Y2K stuff so I havent been reading very much news so maby this is something that are already solved, it is just me that don't know.. (I hope, I hope)

Comments, question are most welcome, but please don't provide an answer immidiatly. The one with the best solution will be well-paid.

perove
LVL 9
peroveAsked:
Who is Participating?
 
JimMorganConnect With a Mentor Commented:
Thanks for the Answer.  I'll certainly keep you posted on anything that I/we work out.

Jim
0
 
JimMorganCommented:
Here is the latest from Microsoft:
 
Remove the installation of Access 97, and then re-install it to a folder other than the default folder. To do so, follow these steps.

NOTE: Because there are several versions of Windows, the following steps may be different on your computer. If they are, please consult your product documentation to complete these steps.


Click Start, point to Settings, and then click Control Panel.


In Control Panel, double-click Add/Remove Programs.


Select Microsoft Access 97 or Microsoft Office 97 Professional from the list of products and click Add/Remove.


In the Maintenance Mode dialog box, click Remove All to remove Access 97.


Search you hard disk for a file named hatten.ttf and rename it to hatten.old if found.


Rename MSAccess.exe to Masques.old. The MSAccess.exe file should be located in C:\Program Files\Microsoft Office\Office.


Install Access 97 to a new folder, for example, C:\Program Files\Microsoft Office\Access 97.

Installations from the Office 97 Professional Compact Disc Only: Depending on the options that you select during a Custom installation, you may receive the following error during the reinstallation process:
Bdrintl.dll was unable to register itself in the system registry.
If this happens, quit the Setup program and do the following:

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).


On the Start menu, click Run.


Type Regedit and click OK.


In the Registry Editor, delete the following key:


HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\MSO97.dll
Close the Registry Editor.


Run the Office 97 Setup program again.

For additional information about the Bdrintl.dll error during setup, please see the following article in the Microsoft Knowledge Base:
Q162295 OFF97: Err Msg: "Bdrintl.dll Was Unable to Register Itself"
Rename MSAccess.old to MSAccess.exe.


All of your applications should now work.
 
Jim
0
 
peroveAuthor Commented:
Thanks Jim,
I will try this in practice on my test machine.
Any other are most welcome to contribute on the discussion

perove
0
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.

 
JimMorganCommented:
I didn't read the question completely before I jumped in with a comment.

That was a generic explanation for having Access 97 and Access 2000 installed at the same time.

The same thing applies for installing the RunTime version of ODE97.  However you need to install Access 2000 in another directory other than Microsoft Office\Office.  That is the directory that the Setup program for the 97 runtime wants to install its program.

You also need to do the renames that are mentioned in the earlier comment.  I notice that I made a typo in naming the Access 2000 exe to old.

Basically, the two programs do run together as long as they are in separate directories.  Unfortunately I do not know of a way to change the default directory for the runtime, which is really knowing more than a reduced set of Access 97.

You're pretty close to knowing what the problems and solutions are with your research.  We are currently installing a few hundred runtime apps on a variety of machines with different versions of Windows and Access so hopefully we have run into all the variations.  So far, so good.

Jim
0
 
dsegardCommented:
null
0
 
TrygveCommented:
I usually install both/all version in non-default folders

Office97
Office2000

etc.

But, from time to time some program will install components into a default Office directory anyhow.

These problems can be really frustrating and even more so when you are dealing with large computer departments which don't see the need for these folder alterations, and do not want to "change the corporate ways of installing procedures etc. etc."

Hope JimMs comments help!
0
 
peroveAuthor Commented:
Thanks Jim, renaming the file did work.

Still I hope for a "better" solution, anyway to "trick" the setup.ini on the ODE setup for ex.

Thaks a mill anyway, hope you don't mind me keeping the Q open for a few days just in case someone has some tip & trick to share.
You will be rewared. (not in heaven but on EE... :))


Thanks again.

perove
0
 
JimMorganCommented:
No problem...  I'd like to see some new trick also since I have the same situation coming up now and then.

Jim
0
 
peroveAuthor Commented:
Jim, do you have the Q????? from where you have picked your first comment??

perove
0
 
JimMorganCommented:
I'm sorry that I can't find it at this time.  I picked up the information a few months back as we were going to be distributing ODE97 apps to users with Access2000 and were concerned that they might have problems.  I edited the article and put it in my electronic reference library.

I just took a few minutes trying to find it in the Knowledge Base.  I could not.  Therefore I believe that I found it in one of the ISV developer's databases.  If I run across it again, I'll let you know.

Jim
0
 
TrygveCommented:
The solution looks very much the same as that used when you get problems from having installed Publisher 97 on a machine and then try to reinstall Access. Perhaps this would be a nice place to look?

Hatten.ttf is also part of this problem. Strange that a font file should have so powerfull effects on a computer :-))
0
 
peroveAuthor Commented:
Still I have problems on some users, even if I rename msaccess.exe to something else, un-install access97 and also delete the whole folder I get problems, no office folder under the catalogue I specified (and also no msaccess(97).exe installed.

On another customer I from time to time get the MDW involved in "my" applcation corrupt. I replace the mdw and it is OK for a time again. The symptomes for the user is that he gets the login window, enter the password and nothing happen.

Any tip?
perove
0
 
JimMorganCommented:
The MDW is actually a Microsoft Jet Database.  The MDW contains several system tables that Jet used to store security information.

Knowing this fact can help to determine why the file is being corrupted.

If the MDW is flagged by the network as default, NRO - Nonshareable Read Only, for example, then only one person access the MDW at a time and Jet will not be able to properly make changes to the system files.  Even NRW - Nonshareable Read Write - would lock user B out while user A is in the process of logging in.  If user A starts the app and leaves the login dialog up while they take a break, this would prevent anyone else from getting in.

If the MDW were properly flagged, SRW - Shareable Read Write, and leaves the login dialog up and goes on break, Jet might have a problem correctly working with the system files.  If the users computer is turned off in the middle of the login dialog, the MDW can be corrupted.  If computer is turned off before all the files close or without going through a shut down to flush the buffers, the MDW can be corrupted.

In essence it is the operator with their actions that corrupt files 90% of the time.  The other 10% is a faulty machine.

Jim
0
 
peroveAuthor Commented:
Thanks Jim,
Already checked the good old "network rights" thing when it comes to corrupted MDA/MDW.
My theory goes more in a direction of when the run-time has been installed using the renaming tequniqe, som registry setting will be missing.

Thanks again, I leave the Q open for the weekend, and if you have more of your excellent comments-> you know where to put them

tia

perove

PS
I spend almost two hours searching MSKB for the article. I suspect MS for removing it.

PPS
Sorry for my bad english, before I get my cofee/cigarette in the morning, It is not the best.

0
 
JimMorganCommented:
I believe that I have a list of the registry settings some place but who the heck wants to spend time messing with those.

I should have a final copy of 2000 next week.  I have a beta copy and decided not to install it while I was finishing my latest project with 97.  After these babies are shipped, I might devote one of my machines to checking out what is really going on.

Your English is about a good as mine despite the lack of coffee and cigarette.  I seem to be up a lot late at night - 12 midnite to 4 am - working with the eastern europeans.  Its surprising that I can write in any language.

Jim
0
 
PinnaclePrCommented:
perove,

I share your desire to find a better solution.  I too am struggling with this issue.  I develop and market an MS Access 97 run-time app.  Have had several customers have problems if they have MS Access 2000.  I have posted my question at:
http://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=10230746 

Anyone who answers perove's question here can also have the points for my question.

BTW: When I first contacted MS about this issue a few months ago, the guy thought for sure that there was a KB article about it.  However, he couldn't locate it.  Wonder if MS did in fact recall it....hmmmmm

Later,
Paul
0
 
JimMorganCommented:
perove:

I guess you saw my comment in pinnaclepr's question.
0
 
peroveAuthor Commented:
Jim,
Don't think anything new will come along for now, provide an answer.

To all the rest:
This discussion also continues on PinnaclePR Q at:

http://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=10230746 

I trust you to leave a note here if you find someting new Jim. Thanks

perove
0
 
peroveAuthor Commented:
Thanks again
0
 
JimMorganCommented:
And thank you for the great grade.  I think that this moves me up to 9th or maybe even 8th place.  (And all I ever wanted to do was get into the top 15)  :-)


Jim
0
 
JimMorganCommented:
Ouch!  There is a BIG gap between you and I on the chart.  Sigh, take a vacation for about 2 months and let me catch up.  :-0
0
 
peroveAuthor Commented:
Actually, I havent been on EE for a few months, ( I been doin' some real works)

But with this speed you will soon be reaching 100' limit and prop. before me.

perove


0
 
JimMorganCommented:
I don't think so.  I'm trying to break this addiction (it is as bad as gambling, so I'm told) and cut back on my time.  Also since I'm finishing up a 2.5 year project, I have to get back to do real work as well.  Either I have to start a new venture, which I'm working on for some EE experts, or get hired as the VP Engineering for some software company.

Jim
0
All Courses

From novice to tech pro — start learning today.