Access 97 vs Access 2000 Training

[lgvelez]

I am working as an Access 97 DBA. (This company moves very slowly ... and will probably not consider an Office2K upgrade for at least 6 to 9 months.) The job requires a super user, ie. no VBA programming necessary. I have used MS Access since ver. 1, so can handle my job requirements very well. I want to move into the Programing area, and would like to use the CD training. Keystone has an excellent series of CD's on Access 2000 Developer. My question is: how similar are VBA5 and VBA6, and would I cause myself problems with Access 97 using Access 2000 training material?

 

[rbowes]

There are significant differences between A97 and A2K.&nbsp;&nbsp;When you start learning VBA programming in A97, nearly everything that you do will be in Direct Access Object (DAO).&nbsp;&nbsp;A2K uses mainly ActiveX Direct Objects (ADO).&nbsp;&nbsp;While you can still use DAO in A2K, everything that I have seen from microsoft and nearly all forums seem to agree that sometime in the future microsoft will stop supporting DAO.&nbsp;&nbsp;So, I would suggest getting some books on A97 and just before your company's conversion to A2K, take the A2K programming course(by the way, I am an A2K convert.&nbsp;&nbsp;I think it works better and there are some great features that A97 doesn't have and I can't seem to make myself go back).<br><br>Good Luck.<br>

 

[lgvelez]

Thanks for answering! I agree with you about Access2K ... the little bit I have seen it, I like it. However, I have heard some negative things about its reliability, etc. Did the SR1 fix those problems?

 

[elizabeth]

I haven't had any significant problems either, other than ones related to conversion and installing multiple versions on the same PC. I've posted links under those topics in the FAQ area of this forum that can help you avoid those problems. One of the links also goes into specific details about the differences in ADO. It may also mention whether the latest version of ADO is downloadable and backwards-compatible. If so you could begin using that immediately.