[AccessD] Poll: How many versions of Access are you running on one machine? X Posted

I have Office 97, and Office 2000 developers Edition installed on 3 machines
(work machine, home machine, and laptop).

When dealing with Access work, almost everything I am getting is 2000.  I
would say that at least 80% of the access work (I do for contract stuff) is
in Access 2000.  The rest is 97.  Now, at my full time job, it is STRICTLY
Access 97, because our entire office is still using Office 97 (with some
upgrades for components like Front Page and Outlook).

Now, that is strictly dealing with Access only applications.  When I am
working with web pages, in house is STRICTLY 97.  As far as contract stuff,
it's split.  Some are 97, some are 2000.  However, if I am building from
scratch, I use 97 as the backend.  This includes VB and/or ASP front ends.
One note on this, when I build this applications, I use ADO to connect to
the Backends.  I also use the Microsoft.Jet.OLEDB.4.0 provider, which
connects to either 97 or 2000 database sources.  I do this for 2 reasons.
Back when I started writing VB front ends, the current service pack for VB
6.0 had a quirk in it (either the service pack or the version of MDAC, don't
remember which), which caused all sorts of odd behavior when using the
provider specifically for Jet 3.51.  However, the provider for Jet 4.0
didn't have the issues, and worked the same with Access 97.  Secondly, if
there is ever a reason to upgrade a backend from 97 to 2000, I don't have to
change the FE code, because it doesn't care.

Drew

-----Original Message-----
From: Joe Hecht [mailto:jmhla at earthlink.net]
Sent: Wednesday, November 19, 2003 7:36 PM
To: AccessD; ACCESS-L
Subject: [AccessD] Poll: How many versions of Access are you running on
one machine? X Posted


I have one machine and Access 97, 2000, XP and 2003. 
 
The OS is win XP.
 
How many people have more than one version of Access on one machine.
Which versions? What are most clients still using?
 
Thanks
 

Joe Hecht

Los Angeles CA

 

 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com