Difference between 97 and 2000

[Michael]

I am teaching a small Access class in a few weeks. The students have Access
97 and I have Access 2000. For the students, I am converting the Access 2000
practice files to Access 97. I understand that the character set between the
two versions are different, but from the screen shots of Access 97 I have
seen on the web (I don't have a copy) look very similar to Access 2000. The
class will be mostly about queries, forms, and reports.

For someone who knows both versions well, will I be able to teach this class
without any problems if I convert the 2000 files to 97 files? Are the
features between Access 97 and 2000 pretty much the same?

 

[Douglas J. Steele]

For the most part, they're the same. Since you have Access 2000, take a look
at the "What's New" in the help file.

 

[Guest]

Doug,

I am very familiar with both versions. I can name several differences.
- the biggest difference in converting the db from 2000 to 97 is that 2000
uses ADO connections as a deault and 97 uses DAO. If you do a search on the
web you can find the code differences. It potentially could give you a hard
time converting backwards.
- Another good thing to mention (for them to upgrade) is the advantage of
..adp and SQL Server.
- Other small differences like "Link Table Manager" is now under Utilities
rather than "Add-Ins"
- defaults such as importing files with a .txt and not excepting user
defines extensions

The building os q,f,r should be very similiar, but how you going about
getting the data could be drastically different. Hope the class goes well.

 

[Arvin Meyer [MVP]]

Another difference, not previously mentioned, is Conditional Formatting
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access