Use ADOX to Create Access Tables

摘要

ADO can't take care of all Access development tasks. See how ADOX can let you: 1. Create tables, columns, and indexes 2. Create relationships 3. Manipulate an object's security properties 4. Write code that's easier to reuse. If you've been working with Access a long time, you probably use the ActiveX Data Objects (ADO) library on occasion (or maybe even a lot). What you might not know is that ADO has a sibling library known as ADO Extensions for DDL and Security (ADOX). You might think that if you haven't needed it before, you don't need it now. You might be right. However, what you don't know can hurt you, because ADO can't take care of everything. Learning ADOX—or at least being familiar with what ADOX can do that ADO can't—will benefit you in the end.