[AccessD] ADP vs Access mdb/SQL

We also have a bunch of legacy A2 applications.  IMHO, it is the most stable
version of Access (HINT: there is no /decompile option, because it's not
needed!).

What amazed me when I was porting some apps over to A2K was the performance
difference, particularily on code execution.  I believe it was Charlotte who
pointed out that AccessBasic was developed using assembler, and therefore is
extremely tight.

Another nice surprise was that all of these apps run happily in any OS -
3.11-XP.  Even with 16-bit OCX controls and a ton of Win16 API calls,
everything behaves perfectly.  I guess I have a hard time going along with
people who say that MS refuses to support previous versions of their
product.

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Friday, April 04, 2003 3:08 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] ADP vs Access mdb/SQL


Hi Susan

> Gustav, I think you might be surprised at the number of folks still
running
> 2.0 or even 95.

No, we have clients here running 2.0 apps on everything from Win95 to
WinXP. It runs extremely stable - actually I can't remember a
breakdown for years. On the other hand we have no clients running Win
3.1x.

> Did 95 run on 3.x?

No. It was pushed as a 32 bit version of Access for Windows 95.
Contrary to the rumors it can run very stable (a client had one
running with four users for five years without a single issue) but as
Access 95 was so quickly replaced by Access 97 that you hardly see any
Access 95 apps any more.
It's like Access 1.x and 2.0 - Access 1.x apps are very rare because
they are easily converted to 2.0.

/gustav