DAO references in Access 2003

[Waldemar]

I will be upgrading Access 97 application to version 2000. It will be used on
different computers. Some may have Access 2000, some may have Access 2003.
1.Once application is updated to version 2000 it will run fine on all
versions of Access (2000 and later), is that correct?
2. I will keep the DAO reference in the project. If computer has only Access
2000 or 2003, but no Access 97 installed on it, will it have DAO components
installed? Will my application (references) work OK?
Thanks,
Waldemar

 

[Albert D. Kallal]

2. I will keep the DAO reference in the project. If computer has only
Access

2000 or 2003, but no Access 97 installed on it, will it have DAO
components
installed?

Yes. And, if you lets ms-access *convert* from 97 to a2000, then the dao ref
is put in automatically for you in a2000, and a2002. For a2003, Microsoft
did something really nice, and brought back the dao reference by default!!
(sweet how MS listed to the people in the newsgroups!).

So, all versions fully support dao, and you don't need any special installs.
If you "import" the forms and code from a97 into a a2000, or a2002, then you
do have to go tools->references and put in the dao ref manually. As
mentioned, in a2003..it is back by default (and popular demand!!).

Will my application (references) work OK?
Thanks,
Waldemar

For the most part yes. However, when in a mixed environment, you can
actually run computers with a97, a2000, a2002, and a2003 and THEY ALL can
use the same data file. You need to use a split database to do this (but,
this recommend for any seasoned developer anyway).

If you have any more references beyond the defaults (such as references to
word, or excel, or outlook), then things can break if one user has a2000,
and another has a2003. IF you used late binding..then problems will be few.
I would suggest that if you have different, or mixed users opening the same
data file..then split..and you can run mixed....and even still run a97 on
some old machines until they are upgraded to a2003 or whatever. So, with a
split system, one computer can still run a97..and the next can run
a2003...and it all works....

 

[Nikos Yannacopoulos]

Waldemar,

See answers below. Just make sure you keep a backup copy safe, before
you do anything!

Nikos

I will be upgrading Access 97 application to version 2000. It will be used on
different computers. Some may have Access 2000, some may have Access 2003.
1.Once application is updated to version 2000 it will run fine on all
versions of Access (2000 and later), is that correct? Yes.


2. I will keep the DAO reference in the project. If computer has only Access
2000 or 2003, but no Access 97 installed on it, will it have DAO components
installed? Will my application (references) work OK?

With a proper installation of Access, it will. Just change the DAO
reference used from 3.51 (or 3.5) to 3.6, after the conversion.

 

[homer]

When you want to convert ac97 to ac2003, do you have to convert it to ac2000
first, or do you go for ac2003 directly? Any differences? And which is the
recommended way?