PC Review


Reply
Thread Tools Rate Thread

DAO vs ADO for setting database security

 
 
Adam
Guest
Posts: n/a
 
      2nd Sep 2003
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...ent/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...ate_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

(remove 'nospam.' from email address to reply)


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up security in a database OssieMac Microsoft Access Security 4 26th Aug 2008 08:06 AM
Setting up Database Security =?Utf-8?B?U2FuZGk=?= Microsoft Access Security 2 13th Jun 2005 12:38 PM
Setting Security on a Database =?Utf-8?B?UGF1bA==?= Microsoft Access Security 4 26th Nov 2004 12:58 PM
Different security setting for different database =?Utf-8?B?SmVmZlA=?= Microsoft Access Security 3 27th Oct 2004 08:28 PM
DAO vs ADO for setting database security Adam Microsoft Access VBA Modules 1 2nd Sep 2003 11:58 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:43 PM.