DAO vs ADO for setting database security

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I am currently embarking on a database project in which I will need to set a
great many security permissions through VBA code, and am faced with the
choice of DAO or ADO.

My understanding is that ADO is the future, and it is generally better to
use ADO than DAO. However, the Mirosoft Access Security FAQ document at

http://support.microsoft.com/support/access/content/secfaq.asp

says that ADO falls far short of DAO when it comes to security, and that it
is better to stick with DAO.

On the other hand, another document on the Microsoft website

http://msdn.microsoft.com/library/en-us/dndao/html/daotoadoupdate_topic7.asp

goes and tells you all the ADO code you need for securing databases, so
whoever wrote that article obviously thinks it works.

Which one should I believe?

Many thanks
 
Adam said:
I am currently embarking on a database project in which I will need to
set a
great many security permissions through VBA code, and am faced with the
choice of DAO or ADO.

My understanding is that ADO is the future, and it is generally better
to
use ADO than DAO.
Click to expand...


(This post won't give you an answer.)

The future is .Net.

Both DAO and ADO are the 'past' (except for the >90% of current VB/VBA
developers for whom they are the 'present').

My impression is that the DAO/ADO debate is largely dead in the context of
Access (since both technologies are dead in MS's eyes!).
IMHO There is no intrinsic benefit in converting an existing app from DAO
to ADO. IMHO it makes little difference to most new Access apps which you
use; indeed you may use both. However, I have never used ADO for security
functions as I still carry the prejudice that DAO is much easier for this
area. As you say, the Security FAQ still says this so I'm inclined to
believe it's still true. But I have no specifics and the Migration to ADO
paper referred to in the FAQ is pretty convincing.

You might want to read this.
http://www.trigeminal.com/usenet/usenet025.asp?1033

Also, there has been loads written on the dao/ado wars in the past so you
might want to trawl through a million or so posts in google.

Just my 2p.

Regards

Peter Russell
 
Back
Top