Differences in Access versinons

T

taccea

What is the difference between
Acces2000, Access2002, Access2003
and AccessXP?

Any input appreciated as long as it is accurate.


Taccea
 
R

Rick Brandt

taccea said:
What is the difference between
Acces2000, Access2002, Access2003
and AccessXP?

Any input appreciated as long as it is accurate.

"Experience-wise" and "big picture wise"...

Access 2000 - New file format (compared to A97) Total piece of crap unless all
updates and patches are applied. First to introduce Unicode which helps if you
need to "internationalize" an app. Also improved replication which was pretty
terrible in A97.

Access 2002 - New file format over A2000, but still uses 2000 format by default.
Basically the release that Access 2000 should have been. This was released as
part of "Office XP" but the XP designation is only accurately applied to the
suite. The individual Office XP programs (Word, Excel , Access) are actually
designated as 2002 (so there really is no such thing as Access XP). Added some
better XML tools.

Access 2003 - Same file format as 2002, still uses 2000 format by default. Most
notable change was the introduction of a security model that just about everyone
immediately turns off.

For the specifics on new features you would have to read the "What's New" for
each on the Microsoft website. Most of it is of little consequence.
 
T

Tony Toews

Rick Brandt said:
Access 2003 - Same file format as 2002, still uses 2000 format by default. Most
notable change was the introduction of a security model that just about everyone
immediately turns off.

I really like the smart tags Access pops up on the controls.

For example I added some &s to some unassociated labels. Access
promptly tells me they're unassociated and gives me an option to
associate the label to a control. Nice.

Or if you've renamed fields in the tables the controls based on the
old names are obviously incorrect. Now a little triangle appears in
the corner. Again nice.

Created my first report and I see a little flag in that little grey
box in the upper left hand corner of the report. I click on it and
see a "Common Report Error" "Report width is greater than page width"
with a bunch of options.

Someone spent some time on these little touches.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top