Install both Access 2000 and 2003 on the same machine.

[T.J.]

I am going to be working on my companies MS Access 2000 to MS Access 2003
conversion project. I am wanting to install MS Access 2003 on my machine,
but leave MS Access 2000 on it as well (so I can work on the old 2000 files
if need be, before they are converted, as the conversion project will
probably take 3 months).

I copied the C:\Program Files\MS Office (folder of MS Office 2000) already.

Is there anything else I need to do, to ensure I don't over write MS Office
2000 and only end up with 2003 on my machine?

Thank you,

T.J.

 

[Alex]

Hi,

If you just install the Access 2003 you will be able to use your Access
2000 MDB's without converting them, as Access 2003 supports both
versions.

I think trying to get both versions of the access programs to co-exist
will be problematic, e.g. which version will be the one run when you
double-click an mdb? You would have to create reasonable complicated
shortcuts for the other version's mdb so that the right msaccess.exe is
executed.

Have you tried to open an access 2000 database in access 2003?

But if you really do want to run both copies of access on the computer,
the rule I use is this.

always install the newest version first, then the oldest, into
different directories. The reason for this is do it the other way round
and it will try to upgrade the older version. Do it newest to oldest
and access 2000 does not see the access 2003 install, they do install
into different directories by default.


Hope it helps.

Regards

Alex

 

[Pat Hartman]

Microsoft recommends installing the oldest version first. If you do it
newest first, you run the risk of the old version installing older versions
of common .dlls which will cause the newer version to fail.

 

[Alex]

Hi Pat,

Here what you are saying and totally understand, I only do the dual
install with MS access and I have never had a problem as long as the
two version are installed into seperate directories. I always use the
latest version of the activex controls that come with vb etc. For me it
comes down to which version I want to be the primary version, and I
install that last. But in the case of this post it is probable that
installing just access 2003 will suffice, as both versions mdb's work
with it.

But If Microsoft are recomending that route then that should be the
route taken unless the person doing it is happy they understand what is
going on.

Thanks for the comment I am always willing to learn.

Regards

Alex

 

[Immanuel Sibero]

Hi all,

If you just install the Access 2003 you will be able to use your Access
2000 MDB's without converting them, as Access 2003 supports both
versions.

That's correct.

I think trying to get both versions of the access programs to co-exist
will be problematic, e.g. which version will be the one run when you
double-click an mdb?

Not really. Should be no problem if you install older versions first.
If you double click on an mdb, the version of the last Access session will
be used. So if you last used A2000, then double clicking an mdb will bring
up A2000.

always install the newest version first, then the oldest, into
different directories. The reason for this is do it the other way round
and it will try to upgrade the older version. Do it newest to oldest
and access 2000 does not see the access 2003 install, they do install
into different directories by default.

Should be oldest to newest and each should be in its separate directory.

Lots of people have multiple version of Access on the same machine. As a
matter of fact, you almost have to install from oldest to newest to get them
to coexist peacefully. I have A97, A2000, A2002, A2003 and they all play
nice.


Immanuel Sibero

 

[Immanuel Sibero]

T.J.

See the rest of this thread about the fact that you can install multiple
version of Access on one machine. As long as you install older version first
and install each version to a separate directory, you should be fine.

I copied the C:\Program Files\MS Office (folder of MS Office 2000)

already.

I dont understand what you are saying here. Why did you copy the MS Office
2000 folder? Where did you copy it to?
You can not copy \Program Files\MS Office folder from one machine to another
and except it to work. You would have to install from CD. If I have
misunderstood you, I apologize.

You will see posts that say A2003 works on A2000 mdb files. If you have
A2000 on your machine I would use it to develop the A2000 mdb even though
A2003 can do the same. If you choose to use A2003 to develop A2000 mdb, you
should compact and repair and compile the mdb under A2000 before deploying
it.


Immanuel Sibero