Access 97 and Access XP on NT 4

P

Patrick

Probably I am not the first with that problem...
PC's running Office XP on NT 4.0 (SP6a). We have got
third-party MS Access 97 (!) developements and they
delivered .mde, not convertible/upgradeble in Access XP.
I installed beside Office XP a run-time version of Access
97 to get run the third-party apps. I have written a .cmd
to call that .mde with Access 97 explicitly. Funny, after
the application run, all the Access related association
are changed default to Access 97. That is, any non-access-
97 databases we have got to "open with..." MS Access XP.
This works fine, unless you run a Access 97 (the thirt-
party .mde) then it got changed back again. I could
include some registration code to the .cmd to change back
the .mdb, .mde... association on HKLM to MS Access XP
when the third-party .mde got closed.
This all is pretty wired, isn't it.
Got somebody nice and cool hints out there?
thx a lot
 
D

Douglas J. Steele

I have to confess that I'm not 100% sure of the details, but if you look in
the directories where Access is installed, you will find two .SRG
("SelfReg") files, msaccess.srg and wizard.srg. These two files contain all
of the registry keys that get rewritten when Access does this
re-registration. Try creating blank versions of these files, and see how it
works.
 
T

Tony Toews

Patrick said:
Probably I am not the first with that problem...
PC's running Office XP on NT 4.0 (SP6a). We have got
third-party MS Access 97 (!) developements and they
delivered .mde, not convertible/upgradeble in Access XP.
I installed beside Office XP a run-time version of Access
97 to get run the third-party apps. I have written a .cmd
to call that .mde with Access 97 explicitly. Funny, after
the application run, all the Access related association
are changed default to Access 97.

Access of any version automatically changes the MDB and other such
extensions to the version of Access you've just run.

You need to add explicit path and file names of the appropriate
versions of access to all the shortcuts. For example "C:\Program
Files\Microsoft Office 97\Office\msaccess.exe". Including the quotes
if you have any spaces in the path name which is very likely.

There are some programs out there which will automatically start the
appropriate version of Access.

One of those is ACCVER - Allows you to work with multiple versions of
MS Access databases. Detects the version of Access used to create your
MDB, MDE or MDA files and either reports the version number or starts
the appropriate version of MS Access. www.aylott.com.au/software.htm

Subject: INFO: Access 2000/Access 97 Coexistence FEPs (Frequently
Experienced Problems)
http://www.trigeminal.com/usenet/usenet019.asp?1033

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top