I'm still using access97 because of the feature that was taken away in later versions that allowed you to link
to excel spreadsheets and update them directly with update queries. I tried understand code recommendation that
was sent to me years ago but to no avail was I able to figure it out.

Since then our organization standard is to install office 2007 or 2010 on all machines. I have a disk of Access97
that I guard with my life.

Im able to install Access97 on the machine Im currently usings but after the next day of using it, I launch it and Im unable to access
the linked table feature addin feature. So each day I'm forced to reinstall access97 on my machine. Can anyone tell me a work around
for this. Is there a way I can save the addin files somewhere else so that they aren't clobbered by Office 2007? Or could someone
tell me where they are stored during the install or what file contains the addin features. I'm always able to open access97 but some
how when I launch excel 2007 or other office software, it's removing my access to access97 linked table addins.

Your help will be greatly appreciated.

Access 2007 and/or Access 2010 do NOT play nice with previous versions on the same PC. PERIOD!

The ONLY work-around, is to have a machine (whether real or virtual) with ONLY Access 97 on it. Once you add Office 2007 or 2010 to a machine that has earlier versions of Access, the earlier version(s) are hosed.

There is no other work-around. Microsoft expects the world to migrate upwards. That is part of the reason they have pulled support for Office 97.

I know this does not solve your problem, but it is the answer.

hope it helps

Jamel,

I've had some success by choosing a custom path instead of the "default" path when installing multiple versions of Access on the same workstation. I don't know what kind of user restrictions are in force on the workstations you're using, but if possible, try uninstalling A97 and re-installing it with a custom/different path.

Other than that, see what you might be able to do to implement Cybercow's recommendation.


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)

Yep,

Already install it in a different path on my c: hard drive. Always have done that since moving to version 2003. One thing I haven't tried
is installing it on a network drive. Not sure if it would let me do that. May be worth a try.

actually, i have never had problems having multiple access versions on one machine

if your A97 version is not working fully, i can only think you haven't fully loaded all the special features.

if it is just a matter of linking tables, though - you can easily add the features in code anyway. i tend to have a local table including details of all the tables that need to be linked, and iterate this table to create the table defs. it's very rare that i use the linked table manager, although it might be a pain if it was not there at all

could it just be that A97 cannot link to the version of excel you are using. if it is later than Excel97, that might make sense

Another piece of gristle in this stew is that the reason that newer versions of Access can't update Excel sheets is that Microsoft lost a lawsuit; it's ILLEGAL for them to provide software to do so. I fear that even if you use A97, you'll have to forgo installing the Office security updates - one of which I recall turns off this feature - and violate Microsoft's EULA by using a feature of the program which the cannot legally distribute!

I agree with CyberCow that the only way to reliably have 97 and 2010 "play nice" together is to install Windows Virtual PC or another such "virtual machine" software. This will let one physical machine implement two independent operating systems. Installing Access makes hundreds of changes to the Registry, and in my experience, even uninstalling and reinstalling the program doesn't clean all of them out.

I have had Office Pro 97/2000/2003 all on one machine for years. Each is in it's own directory and they work just fine with no problems. Before I tried to install 2007, I ghosted my C drive and proceeded to install Office 2007 in its own directory as well. After that, 97, 2000 and 2003 all failed to work properly, as expected and sometimes not at all. 2007 ran like it was supposed to. I immediately restored my C drive from the ghost image and all was back normal.

The break-over version for multiple instances of Office Pro is 2003. Any version after that will NOT play nice with other versions. Period. I do not even recommend trying to have 2007 and 2010 on the same machine. They really get in each other's way.

If you install Access 2007 and/or 2010 onto a machine that already has an earlier version of Office/Access, you can expect issues. Ghost your drive before you try it though, or you'll be uninstalling all versions of Microsoft Office products and have to start from scratch just to get back to a reliable and stable installation.

Good luck! (IMG:style_emoticons/default/hat_tip.gif)

Jamel,

Digging back into my memory banks, I vaguely recall Access 97 needing a specific font for "registration" - Haettenschweiler font, I believe (you might want to Google that to make sure).

I also vaguely recall that other versions of Access install the same font, but there is something different about the font that may (or may not) be causing Access 97 grief.


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)

Joe - right. Microsoft used the presense of the Hatten font to test for valid installation, but had to be removed before adding the next version up (of Access) AFTER 97 was successfully installed. Strange bit of wizardry there.