[mso] Re: ACCESS Difference ?
- From: "Colli, Anthony G" <Anthony.Colli@xxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 19 Sep 2002 10:28:28 -0400
Jim-
All the versions work the same, but there are differences. Basically it come
down to different versions of the underlying database engine and how the
database engine is accessed. All the versions of Access use JET as the
engine. To work with JET, 97 uses DAO, 2000 and 2002 use ADO. DAO and ADO
are very different, but essentially do the same thing.
2000 and 2002 provide support for connecting to SQL server, 97 does not, but
it can be done.
You can convert up a version but cannot convert backward.
97 has great help files, the others don't.
There are known issues with all the versions, but nothing that should stop
you from using any of them. This is the most common one with 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q263245
If you are doing basic tables/relationships/queries any of the versions will
work fine. If you get into programming the database with VBA then these
things will matter more.
-Anthony
-----Original Message-----
From: Jim [mailto:n1jmm@xxxxxxxxxxxx]
Sent: Wednesday, September 18, 2002 9:45 PM
To: mso
Subject: [mso] ACCESS Difference ?
Time to find out from the experts!
Is there much difference between Access 97, 2000, and 2002 ?
Just the highlights Please?
Any problems I should be aware of with 97 or 2000?
Thanks
-Jim-
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
