Access 2000 & 2003 on same machine

[johnvon]

Can it be done, and if so, how?

Thanks!

John

[Jeff Conrad]

Hi John,

I have 97, 2000, 2002, and 2003 all on the same machine.

The *general* consensus is you install in chronological order
into separate folders by choosing the Custom installation
option and selecting to not uninstall previous versions.

(I have seen posts by people who installed out of order as
well and still had success.)

See this article for more information:

Q218861 ""Running Multiple Version of Microsoft Office"
http://support.microsoft.com/support.../q218/8/61.asp

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"johnvon" wrote in message:
news:UH****************@newsread3.news.pas.earthli nk.net...

Can it be done, and if so, how?

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[Steve]

I have Access97, 2000, XP and 2003 on my computer and it works fine! Install
your versions of Access on order of oldest to newest and put each version in
a separate Programs file. Just carefully follow the install instructions as
they come up on the screen and all should go smoothly.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Very Reasonable Fees
Over 1150 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com

"johnvon" <jo******@earthlink.net> wrote in message
news:UH****************@newsread3.news.pas.earthli nk.net...

Can it be done, and if so, how?

Thanks!

John

[StopThisAdvertising]

"Steve" <no****@nospam.spam> schreef in bericht news:xg*****************@newsread3.news.atl.earthl ink.net...

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Very Reasonable Fees 'Fees in a free newsgroup ????
Over 1150 users have come to me from the newsgroups requesting help '1150 users ????
re******@pcdatasheet.com

--
To Steve:
Over 475 users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

[Steve]

You keep showing everyone what an A#$@&%$ you are !!!!! You don't contribute
anything to the newsfroup. All you do is spew out your garbage. We don't
need you in this newsgroup!!!!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Very Reasonable Fees
Over 1150 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com


"StopThisAdvertising" <StopThisAdvertising@DataShit> wrote in message
news:44**********************@text.nova.planet.nl. ..

"Steve" <no****@nospam.spam> schreef in bericht
news:xg*****************@newsread3.news.atl.earthl ink.net...

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
'Resource ????
Very Reasonable Fees
'Fees in a free newsgroup ????
Over 1150 users have come to me from the newsgroups requesting help
'1150 users ????
re******@pcdatasheet.com

--
To Steve:
Over 475 users from the newsgroups have visited the website to read what
kind of a 'resource' you are... (rapidly increasing..)

To the original poster:

Most people here have a common belief that the newsgroups are for *free
exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell
his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

[johnvon]

Thanks to all for the suggestions!

John

"johnvon" <jo******@earthlink.net> wrote in message
news:UH****************@newsread3.news.pas.earthli nk.net...

Can it be done, and if so, how?

Thanks!

John

[Frank L]

Another thing to note with multiple versions on the same machine: if
you open a database by doubleclicking on a shortcut to the mdb, Windows
cannot predetermine the format type of the mdb file and will use the
most recently invoked version of Access to open the file.

So, if you last opened an Access 97 format database and you doubleclick
on a shortcut to a database for an A2002 database, Windows uses Access97
to open the file and you get a message that the mdb has an illegal file
format. If you keep some shortcuts pointing directly the the
msacces.exe files in Office 11, Office 10 etc you can use them to open
the versions of Access you need for the file type involved.

johnvon wrote:

Thanks to all for the suggestions!

John

"johnvon" <jo******@earthlink.net> wrote in message
news:UH****************@newsread3.news.pas.earthli nk.net...

Can it be done, and if so, how?

Thanks!

John

--
F L
-

[Wayne Gillespie]

On Sun, 12 Mar 2006 18:05:00 -0500, Frank L <Le***************@sympatico.ca>
wrote:

Another thing to note with multiple versions on the same machine: if
you open a database by doubleclicking on a shortcut to the mdb, Windows
cannot predetermine the format type of the mdb file and will use the
most recently invoked version of Access to open the file.

So, if you last opened an Access 97 format database and you doubleclick
on a shortcut to a database for an A2002 database, Windows uses Access97
to open the file and you get a message that the mdb has an illegal file
format. If you keep some shortcuts pointing directly the the
msacces.exe files in Office 11, Office 10 etc you can use them to open
the versions of Access you need for the file type involved.

See this thread for a work around.

http://groups.google.com/group/comp....fe744e628c4919
Wayne Gillespie
Gosford NSW Australia

[david epsom dot com dot au]

What about the help files? Are you having any trouble there?

(david)

"Jeff Conrad" <je***@ernstbrothers.com> wrote in message
news:11*************@sp6iad.superfeed.net...

Hi John,

I have 97, 2000, 2002, and 2003 all on the same machine.

The *general* consensus is you install in chronological order
into separate folders by choosing the Custom installation
option and selecting to not uninstall previous versions.

(I have seen posts by people who installed out of order as
well and still had success.)

See this article for more information:

Q218861 ""Running Multiple Version of Microsoft Office"
http://support.microsoft.com/support.../q218/8/61.asp

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"johnvon" wrote in message:
news:UH****************@newsread3.news.pas.earthli nk.net...

Can it be done, and if so, how?

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----

[Frank L]

david epsom dot com dot au wrote:

What about the help files? Are you having any trouble there?

Within each environment (A2002 and A97 in my case) the Help is consistent.

However, in my opinion the Help in A2002 took a nosedive (in
helpfulness) compared to help in A97. I also find the A2002 help panels
are slowwww to load compared to A97.

Just by way of example: if you have a memory lapse on the syntax of the
"mid" function, you can't just type "mid" into the Help Index lookup in
A2002 (the help index list jumps from "microphone" to "Microsoft" to
"millimeter" ... no "mid"; you can't even type in "function" and get a
list of functions in which you can drill down ....

So I made a series of shortcuts to the main A97 edition Help files
and keep them handy in a desktop folder

.... like these ( the first two are the ones I use a lot)

\Office\ACMAIN80.HLP
\Office\ACVBA80.HLP
\Office\ACDEF80.HLP
\Office\VBAXL8.HLP

Of course for really critical topics I would probably doublecheck in
A2002 just to see if anything has changed between versions (rare for the
things I do or need to look up).

Maybe I just don't think in A2002-ese but for me A97 Help is the more
helpful.
--
F L
-

[Frank L]

Wayne Gillespie wrote:

See this thread for a work around.

http://groups.google.com/group/comp....fe744e628c4919
Wayne Gillespie
Gosford NSW Australia

Thanks for sharing this .... some nice ideas here that could prove
useful. Currently I've relied on naming conventions to specify the
access version the db is developed in, but of course that would still
require that the user take note of the file name and ensure the proper
version of Access is launched. Generally the only user who has to be
sharp in this respect is me since all the people who use my apps have
single version Office installations.
--
F L
-

[Jeff Conrad]

"david epsom dot com dot au" wrote in message:
news:44***********************@lon-reader.news.telstra.net...

What about the help files? Are you having any trouble there?

Hi David,

No, no problems with the Help files as far as I have seen.

I much prefer however, the ease of use in the 97 Help files
so if I need to search for something (and I'm pretty sure
it existed back in 97) I will start looking in those Help
files first.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[Jeff Conrad]

I've heard good things about this utility for handling opening
different Access version databases:

http://www.aylott.com.au/software.htm

Look for ACCVER - MS Access Version Checker

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"Frank L" wrote in message:
news:UM*****************@news20.bellglobal.com...

Another thing to note with multiple versions on the same machine: if you open a database by
doubleclicking on a shortcut to the mdb, Windows cannot predetermine the format type of the mdb
file and will use the most recently invoked version of Access to open the file.

So, if you last opened an Access 97 format database and you doubleclick on a shortcut to a
database for an A2002 database, Windows uses Access97 to open the file and you get a message that
the mdb has an illegal file format. If you keep some shortcuts pointing directly the the
msacces.exe files in Office 11, Office 10 etc you can use them to open the versions of Access you
need for the file type involved.

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

[david epsom dot com dot au]

My help files are always falling over, then coming back
for a while, then falling over again. Which is one reason
why I've got the shortcut to the A97 help file on my
command bar. I thought it might be because 2003 re-installs,
then 2000 re-installs, then etc etc.

(david)

"Jeff Conrad" <je***@ernstbrothers.com> wrote in message
news:11*************@sp6iad.superfeed.net...

"david epsom dot com dot au" wrote in message:
news:44***********************@lon-reader.news.telstra.net...

What about the help files? Are you having any trouble there?

Hi David,

No, no problems with the Help files as far as I have seen.

I much prefer however, the ease of use in the 97 Help files
so if I need to search for something (and I'm pretty sure
it existed back in 97) I will start looking in those Help
files first.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----

[david epsom dot com dot au]

If you are relying on yourself to look at the name
of the file, an alternative is to change the file
extension.

You can register md0 with 2000, md2 with 2002, md3
with 2003, md8 with 97, and then double-clicking
will automatically open the correct version.

A bit of a pain with mde's, but works well enough
with mdb's.

(david)

"Frank L" <Le***************@sympatico.ca> wrote in message
news:DB*****************@news20.bellglobal.com...

Wayne Gillespie wrote:

See this thread for a work around.

http://groups.google.com/group/comp....fe744e628c4919
Wayne Gillespie
Gosford NSW Australia

Thanks for sharing this .... some nice ideas here that could prove useful.
Currently I've relied on naming conventions to specify the access version
the db is developed in, but of course that would still require that the
user take note of the file name and ensure the proper version of Access is
launched. Generally the only user who has to be sharp in this respect is
me since all the people who use my apps have single version Office
installations.
--
F L
-