I HAVE my forms already designed as dao references
but some body adviced me to convert them to ado references
is it better or not
On general principle it is never a good idea to convert anything that is
working to something else unless you are unhappy with how it is currently
working or unless you want to do it as a learning excercise.
As for DAO and ADO specifically, there is a large "camp" that says you
should drop DAO in favor of ADO because DAO is a deprecated model. The
flaw in that argument is that ADO is now also deprecated. I also feel
that the whole idea of jumping on every new model that comes down the
pike is silly. Switch because you have a need to.
Against server databases there are some legitimate advantages to using ADO
so if you are using a server (or plan to switch to one later) you have at
least some justification for favoring ADO. As long as you are working
against Jet data (an mdb file), then DAO is superior in all the ways that
matter and you would be better off staying with it.
