MS Access Forum / General 1 / July 2006
Loading 2 versions of runtime
|
|
Thread rating:  |
larpup - 10 Jul 2006 18:59 GMT I have computers setup with A97 runtime with mde's. Work perfectly.
I've written an app in 2003 and purchased the Developer extensions. When I load A2003 runtime with my app on a computer that has A97 runtime, I cannot open the A 97 mde's.
I was under the impression that the developer extensionsl allow for having both runtimes on a computer.
1. A97 Runtime loaded first 2. A2003 runtime loaded second.
I've tested the a2003 mde in runtime mode on computer without A97 and it works perfectly. Is there anything I can do to have both runtime versions run on one computer with two different mde's?
Any advise is greatly appreciated.
Regards,
Lar
ManningFan - 10 Jul 2006 19:33 GMT 2 versions of Access can not exist on the same O/S, the only way you're going to do that is with a dual-boot computer. The DLLs for the 2 versions of Access are completely different and will not interract with each other.
> I have computers setup with A97 runtime with mde's. Work perfectly. > [quoted text clipped - 18 lines] > > Lar Sebastian - 10 Jul 2006 19:56 GMT ManningFan a scris:
> 2 versions of Access can not exist on the same O/S, the only way you're > going to do that is with a dual-boot computer. The DLLs for the 2 [quoted text clipped - 23 lines] > > > > Lar False!
You can have two versions (or more) of runtime on the same box, on the same OS. Just make sure that the path to msaccess for each shortcut point to the right 'msaccess.exe' and of course you have installed them in different folders.
Example: ' "C:\Program Files\Microsoft Office\Art\Office10\msaccess.exe " "c:\MyXP_DB.mde" ' for Access XP .mde or .mdb file and ' "C:\MyProgram\Runtime\Office\msaccess.exe " "c:\My97_DB.mde" ' for Access 97 .mde or .mdb file. The same goes for other versions of runtime (A2k, A2k3) or for other combinations of runtime.
Cheers!
Sebastian
Sebastian - 10 Jul 2006 19:57 GMT ManningFan a scris:
> 2 versions of Access can not exist on the same O/S, the only way you're > going to do that is with a dual-boot computer. The DLLs for the 2 [quoted text clipped - 23 lines] > > > > Lar False!
You can have two versions (or more) of runtime on the same box, on the same OS. Just make sure that the path to msaccess for each shortcut point to the right 'msaccess.exe' and of course you have installed them in different folders.
Example: ' "C:\Program Files\Microsoft Office\Art\Office10\msaccess.exe " "c:\MyXP_DB.mde" ' for Access XP .mde or .mdb file and ' "C:\MyProgram\Runtime\Office\msaccess.exe " "c:\My97_DB.mde" ' for Access 97 .mde or .mdb file. The same goes for other versions of runtime (A2k, A2k3) or for other combinations of runtime.
Cheers!
Sebastian
Terry Kreft - 10 Jul 2006 20:20 GMT Rubbish, I have in the past had Access2, Access97, Access2k, AccessXp and Access2003 all loaded on the same PC under the same OS at the same time.
 Signature Terry Kreft
> 2 versions of Access can not exist on the same O/S, the only way you're > going to do that is with a dual-boot computer. The DLLs for the 2 [quoted text clipped - 23 lines] > > > > Lar Terry Kreft - 10 Jul 2006 20:23 GMT You have to load them in sequence (A97 followed by A2k3) and they have to be installed in different folders.
You then have to ensure that each mdb/mde uses the correct version, which you can do by using shortcuts.
 Signature Terry Kreft
> I have computers setup with A97 runtime with mde's. Work perfectly. > [quoted text clipped - 18 lines] > > Lar ManningFan - 10 Jul 2006 21:26 GMT And how do you prevent the OCXs in Windows/System32 from being overwritten with each install?
I've worked on networks for several years and have never seen it done, at least not without clusterphuxing your machine. To have 5 versions of Access on the same machine is preposterous, and I apologize for this but I think you're full of crap.
> You have to load them in sequence (A97 followed by A2k3) and they have to be > installed in different folders. [quoted text clipped - 28 lines] > > > > Lar Stephen Lebans - 11 Jul 2006 00:03 GMT Ummm... Terry Kreft has forgotten more about Access then you and I know put together. Further, in this particular case, he is 100% correct. I've always had 3 to 4 versions on my machines without any complications. So do all of the Access MVP's that I know. So do most of the Access developers out there. Everyone it seems, except for you, is capable of following the simple instructions that Terry laid out.
 Signature Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
> And how do you prevent the OCXs in Windows/System32 from being > overwritten with each install? [quoted text clipped - 37 lines] >> > >> > Lar larpup - 11 Jul 2006 00:39 GMT Thank you very much for responding. I will ensure paths are correct and get back.
Regards,
Lar
> Ummm... Terry Kreft has forgotten more about Access then you and I know put > together. Further, in this particular case, he is 100% correct. [quoted text clipped - 51 lines] > >> > > >> > Lar Terry Kreft - 11 Jul 2006 08:39 GMT Well, I'm sorry that in your many years of experience you appear to have failed to achieve any level of competence in installing different versions of Access on one machine under one OS.
A simple review of this problem in Google would have shown you that not only is it possible, it is achieved by many people (try searching on the phrase "Different versions of access on one machine").
I think I should point out that it is particularly gutless to apologise before abusing someone. Luckily in this case having demonstrated to the world that you are incompetent, gutless, rude and ill-informed I believe that most people will be able to decide the level of confidence they should have in any further posts of yours and will be able to make an informed decision as to whether they need to spend any of their valuable time reading anything you post.
 Signature Terry Kreft
> And how do you prevent the OCXs in Windows/System32 from being > overwritten with each install? [quoted text clipped - 36 lines] > > > > > > Lar ManningFan - 12 Jul 2006 18:41 GMT Guess I peed in the wrong person's cheerios... :o/ You're right, I'll go kill myself now because you feel my posts are worthless.
> I think I should point out that it is particularly gutless to apologise > before abusing someone. Luckily in this case having demonstrated to the [quoted text clipped - 3 lines] > decision as to whether they need to spend any of their valuable time reading > anything you post. Larry Linson - 13 Jul 2006 04:34 GMT > Guess I peed in the wrong person's cheerios... :o/ > You're right, I'll go kill myself now because you > feel my posts are worthless. I'll observe a moment of silence.
Seems I recently had to correct one of your very-confidently-stated responses that was dead wrong, too. I've only got three versions of Access installed on this machine, but like others who've responded, I have had a few more than that on some other machines in the past.
Perhaps you can still be confident, but cut back a little on the arrogance, at least to the point where you aren't quite so ready to accuse people who really know what they are talking about of being FOC because their (perfectly correct) answers don't agree with what you think.
Larry
ManningFan - 13 Jul 2006 14:24 GMT Larry - I've never seen it done on a Novell Network. If you can point out a primer on doing this across a Novell Network I will eat my words in public, on the White House steps while wearing a purple tutu and makeup.
So far as I know, Novell will not allow more than one version of Access to run on the same machine, because it recreates the registry on each load.
> I'll observe a moment of silence. > [quoted text clipped - 9 lines] > > Larry David W. Fenton - 14 Jul 2006 00:46 GMT > I've never seen it done on a Novell Network. If you can point > out a [quoted text clipped - 5 lines] > Access to run on the same machine, because it recreates the > registry on each load. What in the *hell* are you talking about? Access is only every installed on a workstation, not on a server, and there's no such thing as a Novell workstation. The only thing you put on a server is the MDB data file, and that is accessed by workstations through the file system, so installation of Jet or Access is COMPLETELY IRRELEVANT FOR A NOVELL SERVER.
 Signature David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
ManningFan - 14 Jul 2006 13:39 GMT On a Novell network the server controls the content of the workstations. This is how you allow some users to use some programs and other users to NOT use those programs, and how you limit users from installing "sanctioned" programs only. Just because you don't understand a Novell network doesn't give you the right to get all uppity about it.
Oh wait. Now I sound like you.
> What in the *hell* are you talking about? Access is only every > installed on a workstation, not on a server, and there's no such > thing as a Novell workstation. The only thing you put on a server is > the MDB data file, and that is accessed by workstations through the > file system, so installation of Jet or Access is COMPLETELY > IRRELEVANT FOR A NOVELL SERVER. Rick Brandt - 14 Jul 2006 13:59 GMT > On a Novell network the server controls the content of the > workstations. This is how you allow some users to use some programs [quoted text clipped - 4 lines] > > Oh wait. Now I sound like you. None of your (out of the blue) Novell network behavior statements alter the fact that your original comment...
2 versions of Access can not exist on the same O/S, the only way you're going to do that is with a dual-boot computer. The DLLs for the 2 versions of Access are completely different and will not interract with each other.
...is a load of rubbish on all but this very specific Novell environment which you only injected as a lame attempt to salvage an incorrect position.
 Signature Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
David W. Fenton - 14 Jul 2006 15:50 GMT >> On a Novell network the server controls the content of the >> workstations. This is how you allow some users to use some [quoted text clipped - 16 lines] > environment which you only injected as a lame attempt to salvage > an incorrect position. So far as I can tell, it's also wrong on Novell, unless the Novell admin has decided to set it up that way.
 Signature David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
ManningFan - 17 Jul 2006 16:05 GMT Actually, you're wrong. But you're an "Access MVP" so I forgive you.
> None of your (out of the blue) Novell network behavior statements alter the fact > that your original comment... > ...is a load of rubbish on all but this very specific Novell environment which > you only injected as a lame attempt to salvage an incorrect position. David W. Fenton - 18 Jul 2006 00:18 GMT >> None of your (out of the blue) Novell network behavior statements >> alter the fact that your original comment... [quoted text clipped - 4 lines] > Actually, you're wrong. But you're an "Access MVP" so I forgive > you. <PLONK>
 Signature David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
David W. Fenton - 14 Jul 2006 15:50 GMT >> What in the *hell* are you talking about? Access is only every >> installed on a workstation, not on a server, and there's no such [quoted text clipped - 9 lines] > because you don't understand a Novell network doesn't give you the > right to get all uppity about it. I've been working with Novell networks for over 10 years. I do understand tham. I think the way CNEs are trained to set them up is as user-hostile as could ever be possible, but, I do understand them.
If the Novell sysadmin decided to allow users access to Access runtimes in two different versions, they could have access. There's nothing about Novell that prevents this, except, perhaps, sysadmin intransigence.
> Oh wait. Now I sound like you. Your statement as you originally made it was COMPLETELY WRONG.
So far as I'm aware, it's also wrong now that you've narrowed it to Novell networks.
 Signature David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/
Randy Harris - 14 Jul 2006 06:00 GMT * ManningFan:
> Larry - > I've never seen it done on a Novell Network. If you can point out a [quoted text clipped - 19 lines] >> >> Larry There are a great many people on this NG that have multiple versions of Access installed on their systems without problems. If you prefer not to believe them, perhaps you should give it a try yourself rather than prolonging this pissing contest.
 Signature Randy Harris tech at promail dot com I'm pretty sure I know everything that I can remember.
Keith Wilby - 14 Jul 2006 08:35 GMT > Larry - > I've never seen it done on a Novell Network. I'm not surprised. I've never seen a camel in Blackburn town centre either. I wonder why.
Terry Kreft - 14 Jul 2006 09:25 GMT That's obviously because you walk around with your eyes shut Keith, I personally have seen two camels, three llamas and a bandicoot in Blackburn town centre, mind you, when I started taking the pills again I couldn't seem to find them, or indeed Blackburn town centre.
<g>
 Signature Terry Kreft
> > Larry - > > I've never seen it done on a Novell Network. > > I'm not surprised. I've never seen a camel in Blackburn town centre either. > I wonder why. Keith Wilby - 14 Jul 2006 11:11 GMT > That's obviously because you walk around with your eyes shut Keith, I > personally have seen two camels, three llamas and a bandicoot in Blackburn > town centre, mind you, when I started taking the pills again I couldn't > seem > to find them, or indeed Blackburn town centre. Perhaps you'd fallen into one of those 4000 holes ;-)
Keith.
Terry Kreft - 14 Jul 2006 11:41 GMT LOL!
Good link !
 Signature Terry Kreft
> > That's obviously because you walk around with your eyes shut Keith, I > > personally have seen two camels, three llamas and a bandicoot in Blackburn [quoted text clipped - 5 lines] > > Keith. Keith Wilby - 13 Jul 2006 07:59 GMT > Guess I peed in the wrong person's cheerios... :o/ You're right, I'll > go kill myself now because you feel my posts are worthless. Have you thought of changing your handle to "PC Datasheet"?
Terry Kreft - 13 Jul 2006 08:08 GMT I have disagreed with lots and lots of people in he NGs, some of those people I respected before the fact, some I later went on to respect (and some were irredeemable idiots <g>).
There's nothing wrong with disagreeing (obviously) bur it's best to be reasonably certain of your ground before doing so and to be honest resorting to insults normally makes most people highly suspicious of the strength of your arguments and, even worse, usually diverts the thread into less than helpfull paths.
I don't want you to go away, I'd like you to stay here and engage in providing accurate answers to peoples questions and argue/debate points which you disagree with.
There's a lot to learn for _everyone_ in here that's the continuing attraction of participating
 Signature Terry Kreft
> Guess I peed in the wrong person's cheerios... :o/ You're right, I'll > go kill myself now because you feel my posts are worthless. [quoted text clipped - 6 lines] > > decision as to whether they need to spend any of their valuable time reading > > anything you post. Keith Wilby - 11 Jul 2006 08:56 GMT > but I think you're full of crap. Ummm, I think we all know who's FOC here.
Keith.
DFS - 13 Jul 2006 09:13 GMT > And how do you prevent the OCXs in Windows/System32 from being > overwritten with each install? [quoted text clipped - 3 lines] > of Access on the same machine is preposterous, and I apologize for > this but I think you're full of crap. He's not full of crap. For a long time I ran Access97 and 2000 together. Then I added 2003 and had all 3 versions going.
It looks like this in Program Files
http://www.angelfire.com/planet/dfs0/Triple_the_Access_fun.PNG
>> You have to load them in sequence (A97 followed by A2k3) and they >> have to be installed in different folders. [quoted text clipped - 28 lines] >>> >>> Lar
|
|
|