• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 28. Advanced Security Techniques > Choosing Between ADOX, SQL, and DAO

Choosing Between ADOX, SQL, and DAO

Determining whether to use ADOX, SQL, or DAO to implement security can be a tough decision. Because DAO is supported primarily for backward compatibility, I do not recommend it for new development. Choosing between ADOX, SQL, and DAO involves comparing the methods, and determining what is important to you. Table 28.2 provides a list of features afforded by each technology. You should carefully evaluate each feature and decide which implementation of security is appropriate for you.

Table 28.2. ADOX and SQL Comparison
FeatureADOXSQL
Adding users and groupsFull supportFull support
Other account maintenanceFull supportFull support
Granting and revokingFull supportFull support permissions
Querying permissionsFull supportNo support
Managing ownershipFull supportNo support
Backward compatibilityNoneNone
Future supportDefinitelyLikely
Ease of useSimpler thanVery simple DAO
SQL Server compatibilityWorks with SQL Server; doesn't work with all other databasesBetter support than ADOX



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint