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
|
Adding users and groups | Full support | Full support |
Other account maintenance | Full support | Full support |
Granting and revoking | Full support | Full support permissions |
Querying permissions | Full support | No support |
Managing ownership | Full support | No support |
Backward compatibility | None | None |
Future support | Definitely | Likely |
Ease of use | Simpler than | Very simple DAO |
SQL Server compatibility | Works with SQL Server; doesn't work with all other databases | Better support than ADOX |