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.