A2K vs AXP

  • Thread starter Thread starter Bill Stanton
  • Start date Start date
B

Bill Stanton

My question is somewhat multi-faced between
forms, forms-coding and reports. So, I'm hoping
this newsgroup will be accepting of a question
regarding Windows98SE/A2K and WinXP with
Access XP.

I will be migrating my system to XP and installing
Office XP in the process. However, I have two
applications written in Access 2000 that will
continue to operate on Win98SE systems in an
Office 2000 environment. What I need is some
input as to how one does maintenance on the
A2K applications in an XP environment. If I can
simply install Office 2000 currently with Office
XP, then my question is simply answered.
However, I have a suspicion that one cannot
have both versions installed on the same
machine.

What say ye?

Thanks,
Bill
 
You can most certainly can install more then one version of ms-access (some
regulars here have all 3 versions installed a97, a2000, and a2002 (however
before you do this, you need to read some instructions on how to do this.
The idea is simply to install each version into its on directory).

However, you should note that by default access XP uses the a2000 format.
So, in theory, you can install/use access XP, but the resulting access mdb
files can still be used with a2000. This is rather nice, as thus you don't
really need two versions.

However, the above does have ONE catch 22:
You cannot create a2000 mde files with a2002. So, if you by nature
distribute and use mde files for your users (which is a *very* good idea),
then you will have to use the a2002 format (as mentioned, by default a2002
uses the a2000 format. However, you CAN NOT create a2000 mde files with
a2002. So, if you need to create mde files, then you MUST upgrade the mdb
file format to a2002.

The way I am dealing with the above is my development pc as a2002. I can
thus work on both a2000, and a2002 files. For distribution, I have a another
pc in the office with a2000, and I use that pc to create the mde files for
a2000 users. However, you certainly can install both a2000 an a2002 on the
same pc, but as mentioned you only need to do this if you plan to create mde
files (thus a2002 works equally well with both a2000, and a2002 file
formats).
 
In addition to Albert's comments, the other thing to watch for is using new features that
are in Access XP but not in 2000. If you use one of the new features, such as a new
function call, then Access 2000 won't know what to do with it. Check the Access XP Help
file for What's New in Access XP for a listing of these items.

In the VBA help file, go to the Contents tab, then Microsoft Access Visual Basic
Reference|What's New.
 
Albert,
You seem to be using A2002 and XP synonymously.
Is A2002 the Access component of Office XP?
Bill
 
Access 2002 = Access XP

--
Wayne Morgan


Bill Stanton said:
Albert,
You seem to be using A2002 and XP synonymously.
Is A2002 the Access component of Office XP?
Bill
Click to expand...
 
Bill Stanton said:
Albert,
You seem to be using A2002 and XP synonymously.
Is A2002 the Access component of Office XP?
Bill
Click to expand...

Yes.....

access XP = A2002
 
Back
Top